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 are the disadvantages of using querystrings to send data from one page to another?
What is an indexed view?
What is meant by Active-Passive and Active-Active clustering setup?
What are the differences between having and where clause.
Can we perform backup restore operation on tempdb?
What are drillthrough reports?
What is clustered vs nonclustered index?
How to list all tables in the database using odbc_tables()?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are different types of statements that are supported by sql?
What is precedence constraint?
What is store procedure?
How many databases can we create in a single server?
What is a raid and what are different types of raid configurations?
How to connect Azure federated root database and apply federation in entity framework?