Save Procedures despite missing Columns

1

Hello all,

I have a quick question, I couldn't find an answer on google. Is there a possibility to create procedures despite missing columns??? I want to create a procedure and add the missing column lateron but I always get the message 207/stage 16/Status 1 invalid column name. I need this in preparation for my c# scripts that will create the column after execution.
Thank you in advance
kk

2

No, there's no way to have a missing column in non-dynamic SQL in a proc.

You could put a dummy column in there with that name, and then have the c# script drop the column before it adds it back with the actual data type, length, etc..