IndiaBIX

Database - SQL for Database Construction - Discussion

Discussion Forum : SQL for Database Construction - General Questions (Q.No. 11)
SQL for Database Construction
11.
When using the SQL INSERT statement:
rows can be modified according to criteria only.
rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can either be inserted into a table one at a time or in groups.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
3 comments Page 1 of 1.
Sanjay said:   1 decade ago
How to insert multiple rows to table?
Sundar said:   1 decade ago
Example for inserting multiple rows in a table 'Tbl_Topics'.

INSERT INTO Tbl_Topics(TopicID, TopicName)
VALUES
(1, 'Voltage and Current'),
(2, 'Series Circuits'),
(3, 'Parallel Circuits'),
(4, 'Series-Parallel Circuits');
(1)
Raghu said:   1 decade ago
That is called pivoting insert.
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers