create trigger test
On A
For Inserted
As
Begin
Declare @countID int
Declare @i int
Set i=1
Select @countID=a1 From inserted
While (i=@countID)
Begin
insert into B(...) Values(...)
set i=i+1
End
End
On A
For Inserted
As
Begin
Declare @countID int
Declare @i int
Set i=1
Select @countID=a1 From inserted
While (i=@countID)
Begin
insert into B(...) Values(...)
set i=i+1
End
End
create trigger test
On A
For Inserted
As
Begin
Declare @countID int
Declare @i int
Set @i=1
Select @countID=a1 From inserted
While (@i=@countID)
Begin
insert into B(...) Values(...)
set @i=@i+1
End
End
create trigger test
On A
For Inserted
As
Begin
Declare @countID int
Declare @i int
Set @i=1
Select @countID=a1 From inserted
While (@i<=@countID) --------应该是<=
Begin
insert into B(...) Values(...)
set @i=@i+1
End
End
On A
For Inserted
As
Begin
Declare @countID int
Declare @i int
Set @i=1
Select @countID=a1 From inserted
While (@i<=@countID) Begin
insert into B(...) Values(...)
set @i=@i+1
End
End
ON a
FOR INSERT, UPDATE
AS
declare @i int
set @i=a.al
while(@i>0)
begin
insert into b values('va')
set @i=@i-1
end
GO