sqlserver 列触发器

USE [OHKUMADB] GO /****** Object: Trigger [dbo].[test] Script Date: 09/30/2013 14:04:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- Batch submitted through debugger: SQLQuery6.sql|7|0|C:\Documents and Settings\FBSE\Local Settings\Temp\~vs53E.sql

ALTER trigger [dbo].[test] on [dbo].[ｕｓｅｒ] for update as

declare @name1 varchar(20); declare @name2 varchar(20); s

elect @name2 = name from inserted;

select @name1 = name from deleted; print @name2;

print @name1; if(@name2!=@name1)

begin

print '姓名变化';

end

insert into dbo.people(name,age) values('11','13'); print '添加学生成功！';

update [dbo].[ｕｓｅｒ] set name='lijinlong2' where id=1

转载于:https://www.cnblogs.com/btbear/p/3347199.html