create table PRojectManage(ID int identity primary key not null, projectName nvarchar(20)not null,manager_1  nvarchar(10) not null,manager_2  nvarchar(10) not null,monitor nvarchar(10) not null,isFire varchar(2) null ,startTime datetime not null,endTime datetime not null,manager_1tel nvarchar(11) not null,manager_1company   nvarchar(20) not null,manager_2tel nvarchar(11) not null,manager_2company  nvarchar(20) not null,monitortel nvarchar(11) not null,monitorcompany nvarchar(20) not null)select *from projectManageinsert projectManage values('裝機','小明','大明','工程監(jiān)理','是','1990-9-9','2000-9-9','13527748096','13527748096','13527748096','13527748096','13527748096','13527748096')

declare @dt datetime,@today datetime,@a varchar(max),@z datetime set @a=0select @today=CONVERT(varchar(100), GETDATE(), 20),@dt=@todaywhile @a<1beginselect @today=CONVERT(varchar(100), GETDATE(), 20)   while @dt=@today   begin   insert projectManage values('裝機bb'+@a,'小明','大明','工程監(jiān)理','是',@dt,'2000-9-9','13527748096','13527748096','13527748096','13527748096','13527748096','13527748096')    set @dt=DATEADD(SECOND,5,@dt)   endset @a=@a-1end

declare @i varchar(max)set @i=1while @i<1000001begininsert projectManage values('裝機'+@i,'小明','大明','工程監(jiān)理','是','1990-9-9','2000-9-9','13527748096','13527748096','13527748096','13527748096','13527748096','13527748096') set @i=@i+1end