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
- 5695 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 compare the top two records using sql?
What is self contained sub query?
How will you optimize a stored procedure optimization?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is faster join or union?
What are the character string functions supported by sql server 2005?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is sql view?
What is the purpose of linked server configuration in sql server?
Where is my database stored on the hard disk in ms sql server?
Explain the ways to controlling cursor behavior?
What is instead of trigger sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What do you understand by hotfixes and patches in sql server?
How would you choose between a clustered and a non-clustered index?
