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