create
TRIGGER
save_history
ON tb_control
FOR delete
AS
IF @@ROWCOUNT > 0
BEGIN
INSERT tb_ctrlHistor SELECT column_name_1,column_name_12 FROM deleted
END
ON tb_control
FOR delete
AS
IF @@ROWCOUNT > 0
BEGIN
INSERT tb_ctrlHistor SELECT column_name_1,column_name_12 FROM deleted
END
写一个SQL 语句,可以在查询分析器里执行。
循环5次写入tb_test,字段id,name,num;
id为自动编号,name为1,num从1到5
create
table
for_test
(
a varchar ( 50 )
)
declare @i int
set @i = 1
while ( @i <= 5 )
begin
insert into for_test values ( cast ( @i as varchar ( 50 )))
set @i = @i + 1
end
(
a varchar ( 50 )
)
declare @i int
set @i = 1
while ( @i <= 5 )
begin
insert into for_test values ( cast ( @i as varchar ( 50 )))
set @i = @i + 1
end