Hi! I want add every time in cell. When I run script must add word.
declare @tbl as table(id int, name varchar(100))
insert into @tbl(id,name)values(1,'apple')
update @tbl
set name = name+','+'cherry'
select name from @tbl
output:
apple,cherry,cherry