22,210
社区成员
发帖
与我相关
我的任务
分享
1, select RID,sum(price) as totalPrice from Produce_detail
where RID in (select RID in inserted) group by RID
2, declare @RID varchar(50)
select @RID=RID from inserted
select RID,sum(price) as totalPrice from Produce_detail
where RID =@RID group by RID
3, select RID,sum(price) as totalPrice from Produce_detail
where RID ='RD20001' group by RID
//在1,2中RID就是等于RD20001,第3条是显示给值,以测试结果
测试结果
第一条的结果不等于第二条和第三条的结果
第二条的结果和第三条的结果一样
然后我把inserted表的数据放到一个表变量中.
然后再把上面的三条语句的inserted表全部改为表变量,三条结果全部一样,请问大家这是什么原因呢?
RID in (select RID in inserted) -----多个值
select @RID=RID from inserted -----1个值