select @inserdtcount =count(*) from inserted
select @inserdtcount =count(*) from deleted
select @inserdtcount =count(*) from deleted
解决方案 »
- 请教一条记录转换的SQL
- sql2005 中三种函数的异同
- group by 能不能实现模糊归类?
- 请教如何查询到一张表的最后几行~!
- 如何获取与一个基本表相关联的所有视图?
- 排序问题!!!求教各位大虾
- SQL Server 2005 两视图View1,View2单独查询Select * from View1(View2) 都很快, 两视图关联很慢,为什么?
- SQL语句的问题,详情请进。
- 如何将一个excel文件导入MS SQL SERVER,从而成为其中的一个表?
- 关于无限级分类的问题,2个节点的转换
- SQL 语句求助!
- 已知有两台电脑A,B. 分别装有SQL SERVER. 在电脑A上备份数据库mydata ,生成文件mydata.bak。 然后把此文件copy 到B电脑上, 我想用此文件
select @deletedcount =count(*) from deleted
@inserdtcount int,
@deletedcount int;
select @inserdtcount =count(*) from inserted
select @deletedcount =count(*) from deleted
@inserdtcount int,
@deletedcount int
select @inserdtcount =count(*) from inserted
select @deletedcount =count(*) from deleted
@inserdtcount int,
@deletedcount int
select @inserdtcount =count(*) from inserted
select @deletedcount =count(*) from deleted