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