请问我的触发器怎么编译不过？总是提示说“无法绑定由多个部分组成的标识符 "Session.CreateTime"”

[wonderful_abc]

CREATE TRIGGER CheckSessionStatus_DELETE
ON [Session]
FOR DELETE
AS
if DateDiff(minute, DateAdd(minute, 20, [Session].CreateTime), getdate()) > 0
delete from [Session] where ID=(select ID from deleted)

[xuam]

delete from [Session] where ID in (select ID from deleted)

[-晴天]

CREATE TRIGGER CheckSessionStatus_DELETE
ON [Session]
FOR DELETE
AS
delete from [Session] 
where  DateDiff(minute, DateAdd(minute, 20, [Session].CreateTime), getdate()) > 0
and ID in(select ID from deleted)

[wonderful_abc]

谢谢qianjin036a!

[wonderful_abc]

可是到目前为止，还不知道为什么会出现这个错误....

[--小F--]

if exists(select 1 from  [Session] where  DateDiff(minute, DateAdd(minute, 20, [Session].CreateTime), getdate()) > 0)
  delete from [Session] where ID=(select ID from deleted)

[--小F--]

[Quote=引用 4 楼 wonderful_abc 的回复:]
可是到目前为止，还不知道为什么会出现这个错误....
[/Quote]
if不能那么用的 IF后面需要跟BOOL值。

[wonderful_abc]

[Quote=引用 5 楼 fredrickhu 的回复:]
SQL code
if exists(select 1 from [Session] where DateDiff(minute, DateAdd(minute, 20, [Session].CreateTime), getdate()) > 0)
delete from [Session] where ID=(select ID from deleted)
[/Quote]


DateDiff(minute, DateAdd(minute, 20, [Session].CreateTime), getdate()) > 0 不是BOOL值么？