存储过程中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

浙公网安备 33010602011771号