Top 13 Invalid Column Name Sql Pictures. Suprizingly the column does exists in the table still i get this! When i open the stored procedure in my database one of the coulmn is underlined in red and when moved the cursor over it says'invalid column name'.

the issue is that those are both correct.

Specifically, when submitting a parameter via an sql string, instead of ms sql using the parameter as the value to lookup in the column, it was treating the value of the variable as the column name itself. It works fine when using a barcode to look it up through sql. Specifically, when submitting a parameter via an sql string, instead of ms sql using the parameter as the value to lookup in the column, it was treating the value of the variable as the column name itself. Adding the update statement causes sql server to think it can't update a field that.