Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BCP of few records from a big table

Status
Not open for further replies.

gchalise

Programmer
Oct 23, 2009
1
US
I am a beginner and trying to learn database specially Sybase.

I am trying to copy only selective data from table into text file using BCP but I couldn't, I know simple bcp in and out but what if i want to copy records from 10000-20000 from a table which has millions of records?

Any body can help me out plz.
thanks in advance
Micky
 
Create a view that selects the required data
Then bcp out from the view
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top