存储过程中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 
posted @ 2011-03-22 22:57  小锋神  阅读(5362)  评论(0编辑  收藏  举报