May 14, 2002 at 12:29 pm
Hi, I need to use bcp to do a data exporting.
I need to export data from a table.
I am wondering if I can specify the columns or the starting row and finishing row that I need to transfer data.
For example, I have a table my_data.
It contains 5000 rows. but I only want the data between 2000th - 3000th row. Can I do that?
Also, once the row record is inserted to a table, is the rowid for that record fixed?
Thanks in advance.
Abby
May 14, 2002 at 12:36 pm
Can you post your table DDL as you can try the -F and -L bcp commands which are First and Last records bu I don't believe it will work and you will have to make a query to get those records. Also the rowid is not a fixed items on IDENTITY fields can ensure that (and even then you can insert into a row a missing IDENTITY to fill in the gaps), the rowid only will remain the same as long as you do no insert that would go anywhere other than the end.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply