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) 编辑 收藏 举报