SQL(1)

//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