Thursday, 25 October 2012

What is multi Insert? | Teradata Interview Questions

Inserting data records into the table using multiple insert statements. Putting a semi colon in front of the key word INSERT in the next statement rather than terminating the first statement with a semi colon achieves it.
Insert into Sales “select * from customer”;
Insert into Loan “select * from customer”;

No comments: