如何使用sql server 2005在单个查询中更新两个表 [英] how to update two table in single query using sql server 2005

问题描述

先生，

如何使用sql server 2005在单个查询中更新两个表数据

解决方案

你实现这样：

你可以使用一个事务2确保两个UPDATE语句被正确对待。

  BEGIN   TRANSACTION  
 
 更新 FirstTable 
  SET  FirstTable.col1 = '  XXXX' 
  FROM  FirstTable T1，SecondTable T2 
  WHERE  T1.id = T2.id 
 和 T1.id = '  010008' 
 
 更新 SecondTable 
  SET  SecondTable.col1 = ' <温泉n class =code-string> XXXX' 
  FROM  FirstTable T1，SecondTable T2 
  WHERE  T1.id = T2.id 
 和 T1.id = '  010008' 
  COMMIT  

一次，您可以更新单个表的数据。

访问

http://stackoverflow.com/questions/3707815/update-multiple-tables-in-a-single- update-statement-with-left-join [ ^ ]



快乐编码！

:)

HI，



试试这样。



<预lang =sql> 更新表1，表2
SET Table1.LastName = ' DR。 XXXXXX'
，Table2.WAprrs = ' start，stop'
FROM 表1 T1，表2 T2
WHERE T1.id = T2.id
和 T1.id = ' 010008'

谢谢

sir,
how to update two table data in single query using sql server 2005

解决方案

You achieve like this:
you can use a transaction two make sure that two UPDATE statements are treated correct.

BEGIN TRANSACTION

UPDATE FirstTable
  SET FirstTable.col1= 'XXXX' 
FROM FirstTable T1, SecondTable T2
WHERE T1.id = T2.id
and T1.id = '010008'

UPDATE SecondTable
SET SecondTable.col1 = 'XXXX'
FROM FirstTable T1, SecondTable T2
WHERE T1.id = T2.id
and T1.id = '010008'
COMMIT

At a time, you can update data of a single table.
visit
http://stackoverflow.com/questions/3707815/update-multiple-tables-in-a-single-update-statement-with-left-join[^]

Happy Coding!
:)

HI,

Try like this.

UPDATE Table1, Table2
SET Table1.LastName = 'DR. XXXXXX'
,Table2.WAprrs = 'start,stop'
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '010008'

Thanks

这篇关于如何使用sql server 2005在单个查询中更新两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！