27,579
社区成员
发帖
与我相关
我的任务
分享
update book_delivery_order set invoice_no=ex.invoice_no from ex where book_delivery_order.order_sn=ex.order_sn
update book_delivery_order set invoice_no=ex.invoice_no OUTPUT Inserted.invoice_no,Inserted.order_sn from ex where book_delivery_order.order_sn=ex.order_sn
--测试数据
if not object_id(N'Tempdb..#book_delivery_order') is null
drop table #book_delivery_order
Go
Create table #book_delivery_order([invoice_no] int,[order_sn] nvarchar(23))
Insert #book_delivery_order
select 1,N'aaa' union all
select 2,N'bbb' union all
select 3,N'ccc'
GO
if not object_id(N'Tempdb..#ex') is null
drop table #ex
Go
Create table #ex([invoice_no] int,[order_sn] nvarchar(23))
Insert #ex
select 222,N'bbb' union all
select 333,N'ccc'
Go
--测试数据结束
UPDATE #book_delivery_order
SET invoice_no = #ex.invoice_no
FROM #ex
WHERE #book_delivery_order.order_sn = #ex.order_sn
SELECT * FROM #book_delivery_order