27,582
社区成员




create trigger 触发器名
on dbo.H_Hy
for update as
if exists(select username from inserted where username ='tandol')
begin
print '不允许插入tandol'
rollback transaction
end
CREATE TABLE ... (
...
UserName nvarchar(50) CHECK( UserName <> N'tandol' )
)
CREATE TRIGGER TGR_TABLENAME_UPDATE
ON [表名]
INSTEAD OF UPDATE
AS
BEGIN
IF EXISTS(SELECT 1 FROM INSERTED WHERE UserName LIKE'%tandol%')
RETURN
UPDATE A
SET UserName=B.UserName,UsePwd=B.UsePwd
FROM [表名] A
INNER JOIN INSERTED B ON A.id=B.id
END
试下