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
- 5594 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
Can group by and orderby be used together?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are different types of statement?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the security principal at the database level that represents your session?
Is oracle faster than sql server?
What samples and sample databases are provided by microsoft?
How to modify the underlying query of an existing view?
Is BCNF better than 2NF & 3NF? Why?
What program is used to store the data source file?
How to compare the top two records using sql?
Explain the different types of joins?
What do you mean by table and field in sql?
How to copy the tables, schema and views from one sql server to another?
Name the different type of indexes in sql?
