如何运行命令sql update [英] how to run a command sql update

问题描述

示例

 

SQL = 更新    OrderDetails 

SQL = UPDATE    OrderDetails  

SET  OrderDetails.XPRODNAME = Products.ProductName 

SET OrderDetails.XPRODNAME = Products.ProductName 

FROM OrderDetails INNER JOIN  Products

FROM OrderDetails INNER JOIN Products

ON OrderDetails.OrderDetail_Product = Products.Id

ON OrderDetails.OrderDetail_Product = Products.Id

WHERE    （Products.Id = 1）

WHERE     (Products.Id = 1)

推荐答案

示例

sample

 

SQL =  UPDATE    OrderDetails 

SQL = UPDATE    OrderDetails  

SET  OrderDetails.XPRODNAME = Products.ProductName 

SET OrderDetails.XPRODNAME = Products.ProductName 

FROM OrderDetails INNER JOIN  Products

FROM OrderDetails INNER JOIN Products

ON OrderDetails.OrderDetail_Product = Products.Id

ON OrderDetails.OrderDetail_Product = Products.Id

WHERE    （Products.Id = 1）

WHERE     (Products.Id = 1)

这篇关于如何运行命令sql update的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！