C# 查询结果后修改指定的索引数据

UPDATE TGRDA
SET CDABM = STUFF(CDABM, 1, 2, '55')
WHERE CSSND = '2016-2017'
AND LEN(CDABM) = 9
AND LEFT(CDABM, 2) = '05'

 

UPDATE YwYearsList
SET ADDRESS = STUFF(ADDRESS, 1, 2, '19')
WHERE LEFT(HouseID, 2) = '19'
AND Years = '2017'
AND LEFT(ADDRESS, 2) = '17'