I created the task as a copy of another task, which is working OK.
I was able to resolve the issue by deleting everything from the new task and copying everything from the existing task, into the new task.
Tuesday, April 15, 2014
Monday, April 7, 2014
SQL Server View does not return a newly added column
I added a column to a table in a SQL Server DB. A View which does 'Select *' from the table, did NOT return the new column.
Before the change, the definition of the table was -
Column_A Column_B Column_C
I added a new column so the table now has 4 columns -
Column_A Column_B Column_C Column_D
The definition of the view is:
Select * From Table
To get the view to return the new column (Column_D), I had to drop and re-create the view.
Before the change, the definition of the table was -
Column_A Column_B Column_C
I added a new column so the table now has 4 columns -
Column_A Column_B Column_C Column_D
The definition of the view is:
Select * From Table
To get the view to return the new column (Column_D), I had to drop and re-create the view.
Subscribe to:
Comments (Atom)