Sql Server 循环添加日期--(累加到一个字段中)
SQL语句:
update tb_CT set Currentgoodsstate = 'E', Goodsflow = '0000000', Goodsflownowtime = Goodsflownowtime + '-' + convert(varchar(25),getdate(),100) where CtinfoId = '10001'
SQL语句:
update tb_CT set Currentgoodsstate = 'E', Goodsflow = '0000000', Goodsflownowtime = Goodsflownowtime + '-' + convert(varchar(25),getdate(),100) where CtinfoId = '10001'