BCP and -h option?

[sagn]

Hi

I would like to bcp a table into a text file.
the text file must have the results in a paritcular order.

I am trying to specify the order using the -h
option where my hint is 'order'

my command line looks like


BCP db.dbo.tablename OUT H:\table.txt -c
-h "order column_name asc" -U user -P pwd

I get an error saying I have incorrect syntax near key word
order. I have tried adding the word 'by' and got the same erorr.

Any ideas?

Thanks

diane

 

[redapple]

I will give it a shot since nobody answers it.

Does it need a "by" behind the word "order"?
BCP db.dbo.tablename OUT H:\table.txt -c
-h "order by column_name asc" -U user -P pwd

 

[sagn]

I tried that and it dod not

then I tried putting in an entire slect statement
for the -h option
IE -H "SELECT * FROM TABLE ORDER BY COLUMN"
AND IT WORKED...