One Can create Table using a variable. As #1 Answer describe. You can only

Is it possible to create tables in stored procedures using
a variable for the table name?

Question Posted / pradeep

2 Answers
5613 Views
I also Faced
E-Mail Answers

Answer Posted / pradeep

One Can create Table using a variable. As #1 Answer
describe. You can only create a temp (memory) table but can
not create physical table.

It will give an error while attempting to execute : -

Create Table @VariableName( EmpID varchar(10),
EmpNm Varchar(100)
)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do we Backup SQL Azure Data?

106

What are window functions in sql server?

952

How to select an exiting database using mssql_select_db()?

928

Why functions are used in sql server?

906

What are partitioned views?

946

What is the difference between mysql and sql server?

947

What is database mirroring?

1054

What is Service Broker in sql server 2012?

980

What is log cache in sql server?

993

How to bind a view to the schema of the underlying tables?

955

Why do we use trigger?

925

Mention what are the different types of ssrs reports?

146

What do you need to connect php to sql server?

1055

Determine when an index is appropriate?

1024

What are the advantages of policy management?

954