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
- 11484 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
How to find tables without indexes?
Which table keeps information about stored procedures?
Do you know how to store and query spatial data?
What is the difference between varchar and varchar(max) datatypes?
What are Row versions of DataRow?
How can you control the amount of free space in your index pages?
What is the downside of using udf?
When you use @@error and try-catch?
What are points to remember while using the fillfactor argument?
What is sql server agent and what are the two modes of authentication in sql server?
In what version of sql server were synonyms released?
What are the different types of indexes?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are two difference between sql azure and azure tables?
Which are the two editions in which SQL Azure database available?
