Create Trigger User_Del
On a_User
For Delete
As
declare @id varchar(50)
select @id = id from deleted
Delete a_GetAward where a_GetAward.UserID = rtrim(@id)
On a_User
For Delete
As
declare @id varchar(50)
select @id = id from deleted
Delete a_GetAward where a_GetAward.UserID = rtrim(@id)
On a_User
For Delete
As
declare @id int
select @id = id from deleted
Delete a_GetAward where a_GetAward.UserID = rtrim(@id)
On a_User
For Delete
As
declare @id int
select @id = id from deleted
Delete a_GetAward where a_GetAward.UserID = @id
因为 如果 delete 中有多条则只能删除最后一条于 a_GetAward有关的记录
这点可以测试一下
我觉得应该是:
Delete a_GetAward from a_GetAward inner join deleted on a_GetAward.UserID=deleted.ID
这样无论一条还是多条,都可以完成.