存储过程中while循环

ALTER TRIGGER [dbo].[ppppp]
   ON  [dbo].[tbl_admin]
   for INSERT
AS 
declare @n int 
declare @sql varchar(1000)
set @n=0
while @n<2
begin

 Set @Sql='Insert into tbl_admin (account,password,dept) Values(''Hamunet'',''SianChina'',''123456789123'')' 
 Exec (@Sql)  
 set @n=@n+1

end 
原文地址:https://www.cnblogs.com/xiaofengfeng/p/1991954.html