if exists(select name from sosc..sysobjects where name ='userupdate'and type='TR' )
drop trigger userupdate
GOcreate trigger userupdate
on sosc..sosc_cust_user
WITH ENCRYPTIONfor updateAS
IF(((SUBSTRING(COLUMNS_UPDATED(),1,1))>0) or((SUBSTRING(COLUMNS_UPDATED(),2,1))>0))
BEGIN
declare @uid int
set @uid = select uid from bbs_deploy..dnt_users
where username in(select account from deleted del)
--delete from bbs_deploy..dnt_users where username in(select account from deleted del)
delete from bbs_deploy..dnt_users where uid = @uid
insert into bbs_deploy..dnt_users (uid,username,nickname,password,email,groupid)
select @uid,account,linkman,dbo.MD5(password),email,10 from inserted ins
end这行set @uid = select uid from bbs_deploy..dnt_users ,老是报错,是不是我赋值的时候有问题,请大家教教我
drop trigger userupdate
GOcreate trigger userupdate
on sosc..sosc_cust_user
WITH ENCRYPTIONfor updateAS
IF(((SUBSTRING(COLUMNS_UPDATED(),1,1))>0) or((SUBSTRING(COLUMNS_UPDATED(),2,1))>0))
BEGIN
declare @uid int
set @uid = select uid from bbs_deploy..dnt_users
where username in(select account from deleted del)
--delete from bbs_deploy..dnt_users where username in(select account from deleted del)
delete from bbs_deploy..dnt_users where uid = @uid
insert into bbs_deploy..dnt_users (uid,username,nickname,password,email,groupid)
select @uid,account,linkman,dbo.MD5(password),email,10 from inserted ins
end这行set @uid = select uid from bbs_deploy..dnt_users ,老是报错,是不是我赋值的时候有问题,请大家教教我
解决方案 »
- 帮忙解释一下这句话SQL嘛意思!
- 求一句SQL 行转列的
- sql server 2005 装不上
- 简单的问题,关于&字符的?
- sql 2000 用windows身份验证登录 提示 不能产生SSPI上下文
- 关于SQL查询的问题,跪求高手帮助!!
- 在SQL查询语句中怎么查询字段值是一个字符串的子串?
- 一个基础的SQL语句问题,结果基础类的版块没人会,只好在这里问了。如何使用表名进行联合查询
- 特别急-MSSQL2005 数据库不能启动问题-牛人过来
- sql语句真实功能强大,一直以为只有sql,今天才...寻求sql语句,多送
- [求助] 父子关系的表连接时,怎样根据父表的字段条件来查询子表的字段?
- 记录排序
select @uid = uid from bbs_deploy..dnt_usersand
RTFM
drop trigger userupdate
GO create trigger userupdate
on sosc..sosc_cust_user
WITH ENCRYPTION for update AS
IF(((SUBSTRING(COLUMNS_UPDATED(),1,1))>0) or((SUBSTRING(COLUMNS_UPDATED(),2,1))>0))
BEGIN
declare @uid int
select top 1 @uid = uid from bbs_deploy..dnt_users
where username in(select account from deleted del)
--delete from bbs_deploy..dnt_users where username in(select account from deleted del)
delete from bbs_deploy..dnt_users where uid = @uid
insert into bbs_deploy..dnt_users (uid,username,nickname,password,email,groupid)
select @uid,account,linkman,dbo.MD5(password),email,10 from inserted ins
end