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
存储过程中while循环
最新推荐文章于 2024-07-09 17:09:50 发布