Disable TSQL script check?

Question

lets say I have a script like that:

if(some condition) begin select somecolumn from sometable end

Lets say, that "somecolumn" does not exist and the condition is not true, which means the select is NOT executed. Even though the select would not be executed, the script is not valid, Management Studio complains about the missing column "somecolumn".

Question: Can I somehow disable this sort of check so that the script is executed and since the if is not true, it will never notice that the column is missing?

Thanks :-)

There is something seriously wrong with your design if you have to worry about whether a column exists or not. — HLGEM
– HLGEM, Commented Mar 30, 2010 at 17:19

gbn · Accepted Answer · 2010-03-29 15:36:25Z

5

Use dynamic SQL

if(some condition)
begin
    exec ('select somecolumn from sometable') --or sp_executesql
end

It actually makes no sense to run this because of what SQL is. It's not executed line by line: the whole batch is parsed etc in one go and the error is generated here, before anything actually runs in the sense you mean. This is by design...

answered Mar 29, 2010 at 15:36

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

regeter Over a year ago

not 100% This code works for me: IF OBJECT_ID('Reports.dbo.RecordsTable') IS NULL However other approaches with just plain parameter strings to indicate table1 or 2 fail. However the dynamic sql trick always works, but is a bit annoying of course.

Thomas · Accepted Answer · 2010-03-29 15:41:59Z

2

You can create a procedure that references a table that does not exist however that is the only exception to the rule. From the BOL:

Deferred name resolution can only be used when you reference nonexistent table objects. All other objects must exist at the time the stored procedure is created. For example, when you reference an existing table in a stored procedure you cannot list nonexistent columns for that table.

Beyond using dynamic SQL, there is no means to reference non-existent columns in a stored procedure.

answered Mar 29, 2010 at 15:41

Thomas

64.8k12 gold badges98 silver badges142 bronze badges

Collectives™ on Stack Overflow

Disable TSQL script check?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related