huang kai\’s personal blog

bcp is the command line utility to export data from sql2000.
here’s an example how to export by select query:
bcp “select * from log” queryout log.txt -c -Uusername -Ppassword -Sservername