I have a stored procedure which should add a value to an existing field, not replace it. I can't seem to work out the correct syntax to do so.
heres the proc:
SET sHistory = sHistory + @sHistory
WHERE ApplicationId = @id
This procedure doesnt work, ive tried a few different things, but being a newbie to stored procs, I just cant seem to work it out.