1建立数据表
createtablePRojectManage
(
IDintidentityprimarykeynotnull,
projectNamenvarchar(20)notnull,
manager_1nvarchar(10)notnull,
manager_2nvarchar(10)notnull,
monitornvarchar(10)notnull,
isFirevarchar(2)null,
startTimedatetimenotnull,
endTimedatetimenotnull,
manager_1telnvarchar(11)notnull,
manager_1companynvarchar(20)notnull,
manager_2telnvarchar(11)notnull,
manager_2companynvarchar(20)notnull,
monitortelnvarchar(11)notnull,
monitorcompanynvarchar(20)notnull)select*fromprojectManageinsertprojectManagevalues('装机','小明','大明','工程监理','是','1990-9-9','2000-9-9','13527748096','13527748096','13527748096','13527748096','13527748096','13527748096')
View Code
2利用while循环每五秒插入一条数据
declare@dtdatetime,@todaydatetime,@avarchar(max),@zdatetimeset@a=0select@today=CONVERT(varchar(100),GETDATE(),20),@dt=@todaywhile@a<1beginselect@today=CONVERT(varchar(100),GETDATE(),20)while@dt=@todaybegininsertprojectManagevalues('装机bb'+@a,'小明','大明','工程监理','是',@dt,'2000-9-9','13527748096','13527748096','13527748096','13527748096','13527748096','13527748096')set@dt=DATEADD(SECOND,5,@dt)endset@a=@a-1end
View Code
3一次插入N条数据
declare@ivarchar(max)set@i=1while@i<1000001begininsertprojectManagevalues('装机'+@i,'小明','大明','工程监理','是','1990-9-9','2000-9-9','13527748096','13527748096','13527748096','13527748096','13527748096','13527748096')set@i=@i+1end
View Code