如何通过连接两个表来更新gridview中的行 [英] How to update rows in a gridview by joining two tables

问题描述

UPDATE Admin_Branch set BranchName = @ BranchName where BranchCode = @ BranchCode



UPDATE Admin_Tier set TierName = @ TierName where TierCode = @ TierCode







如何将这两个更新语句合并为一个。我想在gridview中使用这些更新行。谢谢

UPDATE Admin_Branch set BranchName=@BranchName where BranchCode=@BranchCode

UPDATE Admin_Tier set TierName=@TierName where TierCode=@TierCode



How can I join these two update statement into one.I want to use these in a gridview to update rows. thanks

推荐答案

更新a，b设置a.BranchName=@BranchName,b.TierName = @TierName来自Admin_Branch内部联接

Admin_Tier b在a.commonclunname = b.commonclunname上a.BranchCode=@BranchCode和b.TierCode=@TierCode

update a,b set a.BranchName=@BranchName ,b.TierName=@TierName from Admin_Branch a inner join
Admin_Tier b on a.commonclunname=b.commonclunname where a.BranchCode=@BranchCode and b.TierCode=@TierCode

其他明智的你只能在单个qtype中完成



UPDATE Admin_Branch

SET a..BranchName = @ BranchName

FROM Admin_Branch a，Admin_Tier b

在哪里a.BranchCode=@BranchCode

和b.TierCode=@TierCode



UPDATE Admin_Tier

SET b .TierName = @ TierName

FROM Admin_Branch a，Admin_Tier b

WHERE a.BranchCode=@BranchCode

和b.TierCode=@TierCode

尝试这可能是正确的

other wise u can do it in single qtype only

UPDATE Admin_Branch
SET a..BranchName=@BranchName
FROM Admin_Branch a, Admin_Tier b
WHERE a.BranchCode=@BranchCode
and b.TierCode=@TierCode

UPDATE Admin_Tier
SET b.TierName=@TierName
FROM Admin_Branch a, Admin_Tier b
WHERE a.BranchCode=@BranchCode
and b.TierCode=@TierCode
try this may be correct

DECLARE @MyTable TABLE（id int）;

BEGIN TRANSACTION

更新表1

SET Table1.Name =''测试''

输出INSERTED.id INTO @MyTable

WHERE T1.field =''你的价值';

更新表2

SET Table2.YourColumnName =''你的价值''

FROM Table2

在m.id上加入@MyTable m = Table2.id;



COMMIT;

DECLARE @MyTable TABLE (id int);
BEGIN TRANSACTION
UPDATE Table1
SET Table1.Name = ''Test''
OUTPUT INSERTED.id INTO @MyTable
WHERE T1.field = ''Your Value'';
UPDATE Table2
SET Table2.YourColumnName = ''Your Value''
FROM Table2
JOIN @MyTable m on m.id = Table2.id;

COMMIT;

这篇关于如何通过连接两个表来更新gridview中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！