IF NOT EXISTS (SELECT *
FROM dbo.sysobjects
WHERE type = 'TR' AND parent_obj IN
(SELECT ID
FROM dbo.sysobjects
WHERE name = 'xgdept')) CREATE TRIGGER [test] ON
dbo.xgdept FOR INSERT,
UPDATE , DELETE AS
UPDATE XGUSERINFO
SET LEVEL = '1'
WHERE (UserName = 'Administrator')提示在"关键字TRIGGER附近有语法错误!",但实在找不出错误啊?
上述语句中涉及的表都是存在的.
FROM dbo.sysobjects
WHERE type = 'TR' AND parent_obj IN
(SELECT ID
FROM dbo.sysobjects
WHERE name = 'xgdept')) CREATE TRIGGER [test] ON
dbo.xgdept FOR INSERT,
UPDATE , DELETE AS
UPDATE XGUSERINFO
SET LEVEL = '1'
WHERE (UserName = 'Administrator')提示在"关键字TRIGGER附近有语法错误!",但实在找不出错误啊?
上述语句中涉及的表都是存在的.
FROM dbo.sysobjects
WHERE type = 'TR' AND parent_obj IN
(SELECT ID
FROM dbo.sysobjects
WHERE name = 'xgdept'))
DROP TRIGGER [test] ////
GO ////
CREATE TRIGGER [test] ON
dbo.xgdept FOR INSERT,
UPDATE , DELETE AS
UPDATE XGUSERINFO
SET LEVEL = '1'
WHERE (UserName = 'Administrator')