var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: PROBLEM WITH bcp
I have a problem with bcp in Query Analyzer.
The sentence is:
bcp SELECT id_categoria from categorias QUERYOUT 'c:\salida.txt' -c
With this sentence, the error is:
Line 1: Incorrect syntax near 'c:\SADD.txt'.
PLEASE, I NEED HELP.
this command works fine..
bcp "SELECT * from pubs..authors" QUERYOUT "C:\salida.txt" -c -S<server name> -Usa -P<password>
database name, server name and quotes around the query are missing from ur BCP command also the file path should be in full.
hmmm, doesn't work for me, has a problem around QUERYOUT
i'll keep looking
This is true!!, the error now is:
Line 1: Incorrect syntax near 'queryout'.
bcp "SELECT id_categoria from categorias" queryout "C:\salida.txt" -c -S<server_name> -U<login_id> -P<password>
It works via the OS command line.
master..xp_cmdshell 'bcp "SELECT * from pubs..authors" QUERYOUT "C:\salida.txt" -c -S<server name> -Usa -P<password>'