这两触发器比较精简,容易理解
1、简单触发器
create trigger [dbo].[triggerlog]
on [dbo].[users]
after update
as
begin
set nocount on;
insert into dbo.[log](logcontent) select '修改前:'+deleted.username+deleted.userrealname+'修改后:'+inserted.username+inserted.userrealname from deleted,inserted
end
2、触发器-包含类型转换
create trigger [dbo].[triggerlog]
on [dbo].[base_user]
after update
as
begin
-- set nocount on added to prevent extra result sets from
-- interfering with select statements.
set nocount on;
insert into [dbo].[log](logname) select '修改前:' +deleted.account+deleted.[password]+convert(varchar,deleted.coin)+'修改后:'+inserted.account+inserted.[password]+convert(varchar,inserted.coin) from deleted,inserted
-- convert(数据类型,值)
end
go
如对本文有疑问, 点击进行留言回复!!
SqlServer2008实例35排名搜索之根据权值返回排名搜索结果
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :‘xx)
PLSQL Developer 13 报错“数据库字符集(AL32UTF8)和客户端字符集(2%)是不同的。字符集转化可能会造成不可预期的后果“
SQL注入--利用floor(rand(0)*2)报错返回信息
Oracle SQL nvl(),listagg() within group(),TO_CHAR(),CASE WHEN THEN ELSE END
SqlServer2008实例32全文索引和全文目录之从全文索引中去掉普通字符串
网友评论