如何写一条insert语句形式如下:
insert into FileInfo(FileName,ShareNum,PageNum,KHBH) values('施工合同',1,1,'该处如何写')功能要等同于同时执行如下两条insert语句:
insert into FileInfo(FileName,ShareNum,PageNum,KHBH) values('施工合同',1,1,'001')
insert into FileInfo(FileName,ShareNum,PageNum,KHBH) values('施工合同',1,1,'002')
先谢谢了!!!!!
insert into FileInfo(FileName,ShareNum,PageNum,KHBH) values('施工合同',1,1,'该处如何写')功能要等同于同时执行如下两条insert语句:
insert into FileInfo(FileName,ShareNum,PageNum,KHBH) values('施工合同',1,1,'001')
insert into FileInfo(FileName,ShareNum,PageNum,KHBH) values('施工合同',1,1,'002')
先谢谢了!!!!!
insert into FileInfo(FileName,ShareNum,PageNum,KHBH)
Select '施工合同',1,1,'001'
Union All Select '施工合同',1,1,'002'
set @mIndex=1001
set @mNumber=3/*输入你要插入记录的条数*/
while @mIndex<=@mNumber +1000
begin
insert into FileInfo(FileName,ShareNum,PageNum,KHBH)
select '施工合同',1,1,right(@mIndex,3)
set @mIndex=@mIndex+1
end