|
-
Jan 15th, 2008, 05:34 AM
#1
Thread Starter
Fanatic Member
Compiler Conditional statements in t-SQL?
What I am trying to do is this:
Some of our customers have SQL server 2000 databases and some have 2005.
Can we create a stored procedure that is put on both systems but has a compiler conditional statement that includes a call to a system function that only exists in SQL server 20005? Thus, if that stored procedure is created on an SQL sever 2000 database, it will not fail to create? When it runs, it simply skips over the bit call to the call to the non-existance system function (because it is wrapped in compiler conditional logic).
Is this possible?
Everything I say is either loose interpretation of dubious facts or idle speculation rooted in irrational sentiment. 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote