Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the values in 5 table at a time Using any
single statement ?
- 6 Answers
- 11954 Views
- Infosys, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / pradeep kumar
INSERT INTO MyTable (FirstCol, SecondCol)
SELECT 'First' ,1
UNION ALL
SELECT 'Second' ,2
UNION ALL
SELECT 'Third' ,3
UNION ALL
SELECT 'Fourth' ,4
UNION ALL
SELECT 'Fifth' ,5
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What program is used to store the data source file?
What is dbcc? Give few examples.
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How to transfer data from a cursor to variables with a "fetch" statement?
How to check if a table is being used in sql server?
Explain following error properties?
Explain filestream storage of sql server 2008?
What is difference between stored procedure and user defined function?
What is triggers in ms sql server?
How would you use user_constraints table in DB?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Does the unique constraint create an index?
how would you improve etl (extract, transform, load) throughput?
What happens if you delete a table that is used by a view?
How do I find sql server instance name?
