MS SQL 2008 will support multi-row insert statements too. http://richardsbraindump.blogspot.com/2007/07/what-new-in-sql-2008-katmai.ht ml
Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 04, 2007 10:47 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite does not support multi-row inserts? I can't confirm whether it is, but Wikipedia claims it is: http://en.wikipedia.org/wiki/Insert_(SQL)#Multirow_inserts Multirow inserts An SQL feature (since SQL-92) is the use of row value constructors to insert multiple rows at a time in a single SQL statement: INSERT INTO table (column1, [column2, ... ]) VALUES (value1a, [value1b, ...]), (value2a, [value2b, ...]), ... This feature is supported by DB2, PostgreSQL (since version 8.2), MySQL, and H2. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
