select right(cast(‘0000000000‘+rtrim(字段) as varchar(20)),7)
declare @i int
declare @qid int
set @i=1
set @qid=100
while @i<50000
begin
insert into Order(orderid,ordername) values(@qid,‘订单名称‘)
set @i=@i+1
set @qid=@qid+1
end
原文：http://www.cnblogs.com/Fooo/p/7794036.html