-
Expert Member
Insert when, Insert all when difference
Insert when syntax is
INSERT
WHEN condition THEN
INTO table_name column_list
VALUES (values_list)
WHEN condition THEN
INTO table_name (column_list)
VALUES (values_list)
ELSE
INTO table_name (column_list)
VALUES (values_list)
SELECT column_list FROM table_name;
Insert all when syntax is
INSERT ALL
WHEN (condition) THEN
INTO table_name (column_list)
VALUES (values_list)
WHEN (condition) THEN
INTO table_name (column_list)
VALUES (values_list)
ELSE
INTO table_name (column_list)
VALUES (values_list)
SELECT column_list FROM ;
What is the difference in their functionality?
Last edited by krishnaindia2007; 12-03-2007 at 11:01 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules