Hi Mark,

You can create a tabel defining column names using variables. See below example:

DECLARE @W_SQL  AS NVARCHAR(2000)

DECLARE @W_ColName_1 AS NVARCHAR(50)

DECLARE @W_ColName_2 AS NVARCHAR(50)

SET @W_ColName_1 = 'Column_a'
SET @W_ColName_2 = 'Column_b'

SET @W_SQL = 'CREATE TABLE...

Thanks Smith..

I tried that also. Since all the rest of my stuff includes multiple batches of CREATE, DROP, INSERT, etc..so i cannot put all these in ELSE part !!

Please think...

Hi SQLBill, Smith,

Thanks for your suggestion.

Yes, I can use USE statement. But, let me tell you that this is a very silly requirement of our client. She does not want to...

Asif,

If it is your first article then I must say -decently written article.

I have also dealt with such situations many times but what I noticed in your solution was that you did...