Invalid Column Name Sql-Error :Executing a stored procedure

Feb 21, 2018
Reaction score
I am executing a stored procedure .... the following command need to be rectified.

set @str = "Update [dbo].[Lists] SET ASREFSER='"+@server+"' where isnull(ASREFSER,'')=''"

exec ( @str )

Error Message as shown by SQL Server 2012 is as follows
Invalid column name 'Update [dbo].[Lists] SET ASREFSER=''.

I confirmed that the column name is correctly spelled.

Please help

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question