Sql Server 循环添加日期--(累加到一个字段中)

 

SQL语句:

update tb_CT set Currentgoodsstate = 'E', Goodsflow = '0000000', Goodsflownowtime = Goodsflownowtime + '-' + convert(varchar(25),getdate(),100) where CtinfoId = '10001'

 

posted on 2015-05-04 20:40  ultrastrong  阅读(1208)  评论(0编辑  收藏  举报