亚洲中文久久精品无码1_亚洲中文字幕久久无码_中文字幕精品亚洲无线码一区_国产亚洲欧美日韩亚洲中文色

sql批量讓日期增加2年的語句

在做項目中應該經常用得到的

大家可以直接復制

可以進行批量修改！

select s1,s8,s12 from hy where s1 in('TSA12099571','TSA12100589','TSA12100590','TSA12100543','TSA12100540','TSA12100036','TSA12110161','TSA12099278')

update hy set s8 = DATEADD(YEAR, 2, s8)  where s1 in('TSA12099571','TSA12100589','TSA12100590','TSA12100543','TSA12100540','TSA12100036','TSA12110161','TSA12099278')