CREATE PROCEDURE titles_sum @@TITLE varchar(40) = '%', @@SUM money OUTPUT
------------------------------------------------^^^^^这就是默认值
AS
SELECT 'Title Name' = title
FROM titles
------------------------------------------------^^^^^这就是默认值
AS
SELECT 'Title Name' = title
FROM titles
go
insert 表 values (1)
go
CREATE TRIGGER 名 ON 表
FOR UPDATE
AS
select a 更新前被删除的数据 from deleted
select a 更新后被插入的数据 from inserted
go
------------测试:
update 表 set a=3