how to insert the values in 5 table at a time Using any
single statement ?
- 6 Answers
- 10683 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 is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Characterize join and name diverse sorts of joins?
What is the difference between a unique key and primary key?
Explain trigger and trigger types?
How many types of local tables are there in sql server?
Which tcp/ip port does sql server run on? How can it be changed?
When would you use a before or after trigger?
What is the maximum number of index per table?
What is update locks?
What is awe?
How do I port a number to sql server?
What is the command used to check locks in microsoft sql server?
What is the difference between clustered index and primary key?
What is difference between commit and rollback when used in transactions?
What are the different ways you can create databases in sql server?
