Is it possible to create tables in stored procedures using
a variable for the table name?
- 2 Answers
- 4668 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
Mention the differences between having and where clause.
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
on line cluster can we make if yes tell me the procedure
Differentiate between mongodb vs. Sql server?
What is the difference in accessing db between sql server vs sql azure?
How is sql server used?
How to provide values to stored procedure parameters in ms sql server?
How to turn on the mssql api module in php?
What are the differences between DDL, DML and DCL in SQL?
How to create a view with data from multiple tables?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are the difference between primary key and unique key? : sql server database administration
when you create a database how is it stored? : Sql server database administration
What method is used by the Command classes to execute SQL statements that return single values?
How does clustered and non clustered index work?
