SQL Server: Invalid Column Name

sql sql-server sql-server-2008 stored-procedures
Kamran Ahmed picture Kamran Ahmed · Sep 22, 2013 · Viewed 224.3k times · Source

I am working on modifying the existing SQL Server Stored Procedure. I added two new columns to the table and modified the stored procedure as well to select these two columns as well. Although the columns are available in the table SQL Server Keeps giving this error:

Invalid column name 'INCL_GSTAMOUNT'

enter image description here

Can anyone please tell me what's wrong here?

Answer

Ric picture Ric · Sep 22, 2013

Whenever this happens to me, I press Ctrl+Shift+R which refreshes intellisense, close the query window (save if necessary), then start a new session which usually works quite well.

Related questions

SQL Server Insert if not exists

I want to insert data into my table, but insert only data that doesn't already exist in my database. Here is my code: ALTER PROCEDURE [dbo].[EmailsRecebidosInsert] (@_DE nvarchar(50), @_ASSUNTO nvarchar(50), @_DATA nvarchar(30) ) AS BEGIN INSERT INTO EmailsRecebidos (De, Assunto, …

Read More
Stored procedure EXEC vs sp_executesql difference?

I've written two stored procedure one with sp_executesql and other doesn't have sp_executesql both are executing properly same results, I didn't get what is the difference here between EXEC (@SQL) vs EXEC sp_executesql @SQL, N'@eStatus varchar(12)…

Read More
Composite Primary Key On Table Variable In Stored Procedure

I'm new to stored procedures and trying to add a composite primary key to a table variable. DECLARE @statistictemp TABLE ( MajorName VARCHAR(50) NOT NULL, SubName VARCHAR(50) NOT NULL, DetailedName VARCHAR(50) NOT NULL, UniversityID SMALLINT NOT NULL, StatisticValue DECIMAL(9,3) ); ALTER TABLE @…

Read More