56,677
社区成员
发帖
与我相关
我的任务
分享
--测试数据
IF not object_ID('#order') is null
drop table #order
Go
CREATE TABLE #order
(
order_id INT ,
order_create_time DATETIME
)
Insert #order
select 1,'2016-1-1 10:01:08' UNION ALL
select 2,'2016-2-2 10:01:08' UNION ALL
select 3,'2016-3-3 10:01:08' UNION ALL
select 4,'2016-4-4 10:01:08'
IF not object_ID('#record') is null
drop table #record
Go
CREATE TABLE #record
(
order_id INT ,
order_create_time DATETIME
)
Insert #record
select 1,NULL UNION ALL
select 2,NULL UNION ALL
select 3,NULL UNION ALL
select 4,NULL
--测试数据结束
--更新语句
UPDATE #record
SET order_create_time = 1
FROM #order
WHERE #order.order_id = #record.order_id
--读取测试结果
SELECT * FROM #record
--删除临时表
DROP TABLE #order,#record