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
What is a transact-sql statement batch in ms sql server?
What is difference between clustered and non clustered index?
What are the advantages of using a stored procedure?
Can you explain what is sql server english query?
What is application role in sql server database security? : sql server security
What is the boxing and unboxing concept in .net?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What do you understand by a stored procedure?
Define model database?
What is difference between sql and sql server?
Is there any difference between primary key and unique with the not null condition?
How to use go command in "sqlcmd"?
What is scheduled job and how to create it?
what happens on checkpoint? : Sql server database administration
Is null vs coalesce?