存储过程中可以写触发器吗?比如下面格式是否正确?
CREATE PROCEDURE pro
(
@ID int
)
AS
BEGIN
INSERT INTO table (ID)
VALUES(@ID)
END
Create trigger trmy
on table
as intset into table2(uid) values(@uid)
go
...全文
234打赏收藏
存储过程与触发器的格式
存储过程中可以写触发器吗?比如下面格式是否正确? CREATE PROCEDURE pro ( @ID int ) AS BEGIN INSERT INTO table(ID) VALUES(@ID) END Create trigger trmy on table as intset into table2(uid) values(@uid) go