sql 触发器

在s表中创建触发器，当删除s表中的一条记录时，将已删除的记录插入到c表中

ALTER TRIGGER [dbo].[loving10]on [dbo].[s]after deleteAS BEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON; -- Insert statements for trigger here print '你删除了一行数据，,但是操作不成功' declare @name char(20) declare @age int declare @sex char(10) declare @datetime datetime select @name = sname,@age = sage,@sex = ssex from deleted insert into c(sname,sage,ssex,date) values(@name,@age,@sex,@datetime) END