sqlsql-serversql-server-2008stored-procedures
SQL Server: Invalid Column Name
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, I keep getting this error:
Invalid column name 'INCL_GSTAMOUNT'
Can anyone please tell me what's wrong here?
Solution
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.
- Postgres unique constraint vs index
- I cannot enable sa account
- Why do I get SQL state:23503 when I try to add a constraint to an existing table in Postgres?
- Add N business days to a given date skipping holidays, exceptions and weekends in SQL DB2
- How do I generate a list of constant string values as rows?
- How can I generate a list of values as rows from a query?
- Splitting a single column (name) into two (forename, surname) in SQL
- Are there any disadvantages to always using nvarchar(MAX)?
- Using Lag / Lead to highlight records that have repeating data
- How to troubleshoot ORA-02049 and lock problems in general with Oracle
- Delete all Users in database
- How do I combine multiple json_group_array for this query correctly?
- Is there a way that i store timestamp with time zone in Postgres and not converting it to UTC
- How do I join these tables to relate chapters, sub-chapters and text entries?
- How to import (Copy/Paste) data from Excel table to SQL query/client
- Calculate total count based on time span
- follower/following relationship
- How to Clear down Query Execution Statistics in SQL Server 2005/2008
- How to fetch products by by parent tags?
- How to get rid of 0 values from extract, as I think it's causing first and last row to aggregate and give false rows in Oracle?
- How to connect to database through SSH using DataGrip
- Oracle Apex tree child node returning multiple times
- How to group 2 table records with added column details
- AND IF using variable in WHERE CLAUSE
- How to identify independent subsets in a transition table
- How do I create a PostgreSQL database using SQL's DDL on pgadmin4?
- Transpose data in SQL with NULL values
- BIT(1) or TINYINT for flags in MySQL
- Select n random rows from SQL Server table
- SQL Server: use CASE with LIKE