sql每五秒插入一条数据一次插入N条数据

王朝学院·作者佚名 2016-08-27

宽屏版字体: 小 | 中 | 大 | 超大

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