Viewing 3 posts - 1 through 4 (of 4 total)
Don't think the RETURN line is needed after RAISEERROR().
November 2, 2015 at 12:22 pm
#1837178
Thanks.
I went with :
SET @cmd = 'UPDATE thisTable SET ' + @FieldName + ' = @Value WHERE thisTableId = @paramId'
SET @parameters = '@Value nvarchar(100), @paramId int'
EXEC sp_executesql @cmd, @parameters, @Value...
November 2, 2015 at 11:42 am
#1837163
Looks awesome, it's definitely down the path I'm going.
Thank you.
October 30, 2015 at 2:02 pm
#1836822