sql server中联合两个表update数据

最新推荐文章于 2024-07-29 04:02:22 发布

yc_jxau

最新推荐文章于 2024-07-29 04:02:22 发布

阅读量7.3k

点赞数

分类专栏： sql server

本文链接：https://blog.csdn.net/u010488899/article/details/74909575

版权

该博客介绍了如何在SQL Server中联合两个表进行数据更新。首先创建了一个新表temp2，将原表T_wStock的数据复制过去。然后通过JOIN操作找出T_wStock中与temp1不匹配的记录，根据条件更新T_wStock表的GoodsStyle字段。最后展示了一些查询语句来检查更新后的数据和原始数据的对应情况。

摘要由CSDN通过智能技术生成

INSERT INTO temp2 --新建一个表，表结构跟原表结构一样，并表原表中的数据插入进去，再做测试
SELECT WarehouseTaskCode, CustCode, GoodsCode, GoodsName, GoodsModel, GoodsPackNum, GoodsPieceNum, GoodsCubage, GoodsWeight, GoodsGWeight, WarehousePosition, GoodsLock, InStockDate, GoodsPrice, GoodsTotalPrice, DamageTag, InStockType, ExpectPieceNum, ExpectCubage, ExpectWeight, ExpectGWeight, NeatenID, Recorder, RecordDate, Modifier, ModifyDate, OriginalCountry, BarcodeNum, BarcodePrefix, GoodsLatchCode, GoodsProductiondate, GateWayCode, GateWayDate, GoodsStyle, BelongToWarehouse, FinanceYear, FinanceMonth, GoodsPackUnit, GoodsPieceUnit, BargainValuta, EradioCode, CIQGoodsFNum, CIQGoodsSNum, XmlCol, Reserve_One, Reserve_Two, Reserve_Three, ZeroDate, GoodsType, DamageTagLevel FROM T_wStock

select COUNT(1) FROM T_wStock
select COUNT(1) FROM temp2

select COUNT(1) FROM temp2

select GoodsCode,GoodsStyle ,htype from 
temp2 inner join temp1 on temp2.GoodsCode = dbo.temp1.num
wher