--循环执行插入10000条数据declare @ID intdeclare @eigyousyocode nvarchar(16)declare @datet datetimedeclare @placecode nvarchar(16)beginset @ID=1set @eigyousyocode='1'set @datet='2015-05-06 17:22:24.990'set @placecode='1'while @ID<=50000begin insert into bs_WorkView(eigyousyo_code,date_t,place_code)values(@eigyousyocode,@datet,@placecode)set @ID=@ID+1endend
转载于:https://www.cnblogs.com/dehuachenyunfei/p/10442106.html
