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

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

What is a transact-sql statement batch in ms sql server?

696


What is difference between clustered and non clustered index?

728


What are the advantages of using a stored procedure?

735


Can you explain what is sql server english query?

753


What is application role in sql server database security? : sql server security

780


What is the boxing and unboxing concept in .net?

731


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1769


What do you understand by a stored procedure?

798


Define model database?

762


What is difference between sql and sql server?

713


Is there any difference between primary key and unique with the not null condition?

728


How to use go command in "sqlcmd"?

885


What is scheduled job and how to create it?

741


what happens on checkpoint? : Sql server database administration

741


Is null vs coalesce?

660