sql查询出多条数据如何保存，帮忙看下代码

Question

ALTER trigger [dbo].[ICStockBill_RWHQ] on [dbo].[ICStockBill]
for insert
as
begin

update [dbo].[ICStockBill] 
set 
  [FHeadSelfB0436]=
  (select [FICMOInterID] from [ICStockBillEntry] where [dbo].[ICStockBillEntry].[FInterID]=(select [FInterID] from inserted))
  ---上面这个插入输入的值查询出来多条，SQL不能保存多条数据，也不能用数组，请大神们帮看看这个多条数据如何保存
FROM [dbo].[ICStockBill] a,[dbo].[ICStockBillEntry] b

--下面判断是否当次添加ID，单据类型是否为‘24’，根据当次ID查找明细表中存在多条[FInterID]项然后判断是否都为 ‘85’
where a.[FInterID]=(select [FInterID] from inserted)
and
(select a.[FTranType] where a.[FInterID]=(select [FInterID] from inserted))='24'
and
(select b.[FSourceTranType] where b.[FInterID]=(select [FInterID] from inserted))='85'
end

Answer 1

http://blog.csdn.net/happy_ddm/article/details/6792317