比较MS SQL中具有相同值的两个表
本文关键字:两个 SQL MS 比较 | 更新日期: 2023-09-27 18:10:14
我有一个包含2个表的数据库,例如
表答:Id: 1
name: ahmed
marks: 5
表B: Id: 1
name: ahmed
marks:
我想比较表B和表a。如果Id
和name
匹配表B, id
和name
则在表B中插入标记。
UPDATE B
SET B.Marks = A.Marks
FROM TableB B
INNER JOIN TableA A ON A.Name = B.Name
AND A.ID = B.ID
c#代码string cs = @"Your connection string bla bla";
using(SqlConnection con = new SqlConnection(cs))
{
string sqlQuery = "UPDATE B SET B.Marks = A.Marks
FROM TableB B
INNER JOIN TableA A ON A.Name = B.Name
AND A.ID = B.ID"
using(SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.ExecuteNonQuery();
}
}