Sql Server 迴圈語句插入，sqlserver迴圈語句

Sql Server 迴圈語句插入，sqlserver迴圈語句

有個表tt

描述為：

q (PK,int,not null)w (nchar(10),not null)e (int,not null)r (int,not null)t (int,not null)y (int,not null)u (int,not null)i (int,not null)o (int,not null)p (int,not null)

迴圈插入語句為：

declare @a intset @a=1while @a<10001    begin    insert into tt (q,w,e,r,t,y,u,i,o,p) values (@a,'a',1,1,1,1,1,1,1,1)    set @a=@a+1    end

MSSQLServer上測試通過~