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

SQL语句:

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