Is it possible to create tables in stored procedures using
a variable for the table name?
- 2 Answers
- 5096 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
How to update a field in SQL after ALTERING a row?
Is null vs coalesce?
How to bind a view to the schema of the underlying tables?
What is surrogate key? : sql server analysis services, ssas
What is the correct order of the logical query processing phases?
What is difference between views and stored procedures?
How to stop log file growing too big?
how to overcome kernel isssues
What is isolation levels?
What are user-defined functions (udfs) in sql server?
What are different replication agents and what's their purpose? : sql server replication
How you can minimize the deadlock situation?
What is the architecture of ms sql reporting service?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is the default schema of your login session in ms sql server?
