CREATE TRIGGER [DELETECourse] ON [dbo].[COURSE]
FOR DELETE
AS
DECLARE @CourseID varChar(15)
SET @CourseID=LTRIM( STR( deleted.Course_id ) )
报错误107:列前缀‘deleted’与查询中用的表名和别名不匹配
...全文
2657打赏收藏
如何得到SQLSERVER触发器(删除型)中DELETED表中的值?
CREATE TRIGGER [DELETECourse] ON [dbo].[COURSE] FOR DELETE AS DECLARE @CourseID varChar(15) SET @CourseID=LTRIM( STR( deleted.Course_id ) ) 报错误107:列前缀‘deleted’与查询中用的表名和别名不匹配