SQL 触发器问题
0
[已关闭问题]
解决于 2012-10-19 01:13
--选课表
CREATE TABLE SC
(
Sno char(10) NOT NULL,
Cno char(10) NOT NULL,
SCfalg bit,
Sgrade smallint,
Snumber smallint,
PRIMARY KEY(Sno, Cno),
FOREIGN KEY(Sno) REFERENCES Student(Sno),
FOREIGN KEY(Cno) REFERENCES Course(Cno)
);
--创建一个触发器，当在选课表SC中插入相应课程号的记录时
--把选该课的学生人数加1
GO
CREATE TRIGGER Insert_SC ON SC
FOR INSERT
AS BEGIN
IF (new.Cno = old.Cno) THEN
new.Snumber = old.Snumber + 1;
END IF;
END;
消息 156，级别 15，状态 1，过程 Insert_SC，第 4 行
关键字 'THEN' 附近有语法错误。
其他回答(2)
0
THEN换成begin。
例如：
- USE pubs IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15 BEGIN PRINT 'The following titles are excellent mod_cook books:' PRINT ' ' SELECT SUBSTRING(title, 1, 35) AS Title FROM titles WHERE type = 'mod_cook' END ELSE PRINT 'Average title price is more than $15.'
0
- USE pubs IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15 BEGIN PRINT 'The following titles are excellent mod_cook books:' PRINT ' ' SELECT SUBSTRING(title, 1, 35) AS Title FROM titles WHERE type = 'mod_cook' END ELSE PRINT 'Average title price is more than $15.'你分开写吧，不然不好看
0
CREATE TRIGGER Insert_SC ON SC
FOR INSERT
AS BEGIN
IF (new.Cno = old.Cno)
BEGIN
update new.Snumber set new.Snumber=old.Snumber + 1;
END
END;
消息 4104，级别 16，状态 1，过程 Insert_SC，第 68 行
无法绑定由多个部分组成的标识符 "new.Cno"。
消息 4104，级别 16，状态 1，过程 Insert_SC，第 68 行
无法绑定由多个部分组成的标识符 "old.Cno"。
@lhui: 是不是还要用什么存储过程啊