新增:
CREATE TRIGGER TriggerName ON TableName
FOR INSERT(或者是UPDATE、DELETE)
AS
……
GO
修改:
ALTER TRIGGER TriggerName ON TableName
FOR INSERT(或者是UPDATE、DELETE)
AS
删除:
drop trigger TriggerName
CREATE TRIGGER TriggerName ON TableName
FOR INSERT(或者是UPDATE、DELETE)
AS
……
GO
修改:
ALTER TRIGGER TriggerName ON TableName
FOR INSERT(或者是UPDATE、DELETE)
AS
删除:
drop trigger TriggerName
要学会自己查资料解决问题。
'sql="CREATE TRIGGER [first_trigger] ON [data] after INSERT AS declare @name varchar(50) select @name=b.name from data as a,inserted as b where b.id=a.id insert into data1 (name) values (@name)"'sql="CREATE TRIGGER [first_trigger] ON [data] FOR INSERT, UPDATE, DELETE AS insert into data1 (num_id,name,subject,score) values (32,'朱司令','程序设计',132)"'''''''创建存储过程
'sql="create procedure first1_proc @name varchar(50) as select * from data where name=@name"'con.execute (sql)
里面很详细
create trigger TriggerName on tablename
for insert(或者是update 、Delete)
as
.....
go
---------------------------------------
修改
ALTER TRIGGER TriggerName ON TableName
FOR INSERT(OR UPDATE DELETE)
AS
-----
删除:
drop trigger TriggerName