[omniORB] Re: BCP question

[Rusty Carruth]

just so everyone (including the original asker) knows

------------- Begin Forwarded Message -------------

From: Rob Bains <Rob_Bains@CdnAir.CA>
To: Rusty Carruth <c1040@azfms.com>

Sorry, I ignored the select part of it altogether.

In that case, the only way I can suggest is that select these records into
a temp table in the tempdb before bcp'ing them out to the file.

I hope this helps.

===== > Rob


On Thu, 29 Jul 1999, Rusty Carruth wrote:

> Subject: Re: BCP question
> 
> 
> > Shane;
> > 
> > Try something like the following:
> > 
> > bcp  <database_name>..<table_name> [in|out] -c -t 'YourFieldDelimiter' -r
> > 'YourRecordDelimiter' -U<username> -P<password> -S<SERVERNAME>
> > 
> well, sure, but that copies the entire table.  He (she?) appears to
> be wanting to only bcp the NEW records, looking at the sql he's trying
> to get to work...
> 
> > Give it a world.  Good luck.
> > 
> > ===== > Rob
> > 
> > On Wed, 28 Jul 1999, shane wrote:
> > 
> > > Here is my command.
> > > 
> > > 1> select * from Guide where dateRecordAdded > "Jul 13 1999 5:00PM"  (I've
> > > also tried select oid, dateRecordAdded etc...)
> > > 2> \bcp -S ServerName AccessMain.access.Account
> > > 
> 

------------- End Forwarded Message -------------


rc

-----
rusty@azfms.com		rustyc@inficad.com	rusty@descomp.com

(If this message is short, then its not meant to be curt,
its meant to be quick.  If its long, well, sorry about
that ;-)