update dbo.user set status='delete' where userid in (select userid from deleted)
解决方案 »
- 100分求助该如何写这个SQL。。。。。。
- 如何快速的根据一个数的值N,生成1-N的编号出来?
- 关联表的插入
- 怎样根据已有的一个表的格式创建新表?
- sql交叉查询去顶一条数据
- 求sql语句 查询表记录,条件是:判断一个字符有没有在字段存储的字符串里出现过
- 求解两道冲突与死锁的题...
- sql server2000如何创建带参数的视图?在存储过程中建视图参数传不进?
- SQL Server 2005 局域网访问的问题
- 怎么用sql语句取出‘2002-10-4 10:01:15:763’当中的‘2002-10-4’ ?
- 我用OpenDataSource查到的列的順序怎麼和Excel中的順序不一樣
- SQL中有类似于MYSQL中limit的语句吗?
FOR DELETE
AS
update dbo.user set status='delete' where userid=deleted.userid--deleted删除、更新时候都有它
--inserted增加、更新都有它
FOR DELETE
AS
update dbo.user set status='delete'
from Deleted a,user b where a.userid=b.userid
FOR DELETE
AS
update dbo.user set status='delete'
from Deleted a,user b where a.userid=b.userid