3044am姘稿埄(闆嗗洟)绉戞妧鏈夐檺鍏�鍙� - 鐧惧害鐧剧��

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')