Invalid Column Name Sql-Error :Executing a stored procedure

A

AmjiBhai

Joined
Feb 21, 2018
Messages
216
Reaction score
86
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

Similar Threads

Syntax Error while running a stored procedue 6
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Call stored procedure with paremeter output in c# 7
From Access how to create stored procedure in SQL server 4
Databinding error using LINQDatasource with stored procedure 12
Fast SQL Server Stored Procedure runs slow in VB.NET 4
the request for procedure 'y' failed because 'y' is a table valued function object 1
Stored Procedure Error Question 3

Top