Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to create tables in stored procedures using
a variable for the table name?
- 2 Answers
- 5791 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
Is there any difference between primary key and unique with the not null condition?
What are the advantages of passing name-value pairs as parameters?
What is policy based management (pbm)? : sql server database administration
What is db stored procedure?
What is the difference between sdf and mdf?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Name and describe few console utilities for ssrs?
What is difference between materialized view and view?
How you can get the list of largest tables in a database?
How to search for a string in all stored procedure in sql server?
What is a derived table?
Do you know nested transaction?
What is shrink log file?
What does the on delete cascade option do?
What do you mean by a Composite primary key?
