触发器代码:
CREATE TRIGGER [dbo].[job]
ON [dbo].[Students]
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
declare @c int, @b varchar;
select @c = MajorID from inserted;
select @b = Majors.Name from Majors inner join inserted On Majors.ID = inserted.MajorID;
PRINT @b;
PRINT @c;
PRINT 'sdjkashdkasjhdka';
INSERT INTO tuchu(ID,NAME,Age,City,MajorID) VALUES(1,'张三',16,@b,11)
END
原意是想通过Students这个表的触发器,触发时插入sql,在tuchu这个表的City字段,通过第三张表Majobs,插入变量@b(希望是'美学'这个字符串),之前成功过,不知道问题出在哪,怎么试都不行了..学习阶段..求大神开导!!!!