//EXISTS
/****** Object: Table [dbo].[aDateTime] Script Date: 02/01/2007 09:53:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aDateTime](
[dt] [datetime] NULL,
[dec] [nvarchar](50) COLLATE Japanese_CI_AS NULL
) ON [PRIMARY]
insert into aDateTime select convert(varchar(10),getdate(),111),'时间1'
insert into aDateTime select convert(varchar(20),getdate(),120),'时间2'
if exists(select * from aDateTime where dt='2007/02/01')
print 'exist'
select row_number()over(order by dt desc),* from aDateTime
else
print 'not exist'
//IDENTITY
select identity(int,1,1) as 序号,area_name as 地区 into #tmp from area
select * from #tmp
//INSERT500DATA
declare @iMax int
declare @iInitial int
declare @strSuffix nvarchar(6)
declare @id nvarchar(9)
select @strSuffix='IPS000'
select @iMax=500
select @iInitial=164
while @iInitial<=@iMax begin
select @id=@strSuffix+cast(@iInitial as nvarchar(3))
insert into mi_equipmentinfo select @id,
'added by cqs',
substring(cast(newid() as varchar(60)),1,30),
null,null,
'A',
null,
'台',
null,null,null,null,
'comment by cqs',
getdate(),
null,null,null,null,null
select @iInitial=@iInitial+1
end