how to insert the values in 5 table at a time Using any
single statement ?
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 convert character strings into numeric values?
What is the difference between Stored Procedures and triggers?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How can you fetch alternate records from a table?
Which data type columns are the best candidates for full-text indexing?
What is the purpose of sql profiler in sql server? : sql server database administration
What is the difference between functions and scalar functions?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is function of master database?
Which sql server table is used to hold the stored procedure scripts?
Which are the two editions in which SQL Azure database available?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is similarity and difference between truncate and delete in sql?
How can windows applications connect to sql servers via odbc?
What is the current pricing model of SQL Azure?