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