Thanks.. Travis
-----Original Message----- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 2:16 PM To: Williams, Travis L Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question) On Tue, 5 Aug 2003, Williams, Travis L, NPONS wrote: > I have a table (lets say a,text b,text) and I want to insert the data > jim,jimmy and trav,travis can I do this with 1 insert into statement > instead of 2? Not with the current implementation of insert. There's been some discussion of adding the multiple tuple insert seen in other databases, but I don't think anyone's actually done it or even agreed on exactly how to do it. I'm not sure if SQL 3 covers this, it seems like it hints at it, but I can't read that stuff all that well most of the time. I don't think there's a way right now though, without using some form of copy. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
