Is it possible to create tables in stored procedures using
a variable for the table name?
- 2 Answers
- 5221 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
What is bookmark link in ssrs?
What is a filestream?
What is store procedure? When do you use?
What is the fastest way to permanently delete a 1 million row table named customers?
What is federation member?
How do you rename a table in sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to loop through returning rows?
What is the difference between resultset and resultsetmetadata?
How many types of database relationship in sql server?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
write an SQL query to list the employees who joined in the month of January?
Explain how dts is used to extract, transform and consolidate data?
What is an index in sql?
Can we perform backup restore operation on tempdb? : sql server database administration
