June 19, 2019 at 6:49 am
First time exporting contents of tables to a txt file. Need to keep NULLs instead of empty blanks that are generated by export wizard. So, want to use sqlcmd.
Tried:
sqlcmd -s servername -d dbname -E -Q "SELECT * FROM [Schema].[dbo].[Inventory]" -s "," -o "\\address.org\vdifolders$\polkadot\Documents\US570333\Inventory.txt"
get error:
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 's'.
Tried
sqlcmd -i servername -d dbname -E -Q "SELECT * FROM [Schema].[dbo].[Inventory]" -s "," -o "\\address.org\vdifolders$\polkadot\Documents\US570333\Inventory.txt"
get error:
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'i'.
basically whatever switch I use after sqlcmd, gives error. It's as though SSMS doesn't recognize sqlcmd utility . Tried turning it on within SSMS by toggling SQLCMD Mode from Query drop down.
Does the syntax look right? Why the failure? Ideas? Suggestions?
--Quote me
June 19, 2019 at 8:56 am
Specifying servername requires uppercase S "-S", specifying separator is lowercase s "-s". -i is for a sql file, usually used instead of -Q or -q.
June 19, 2019 at 1:38 pm
You are using command line sqlcmd, so SSMS is not relevant here.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 19, 2019 at 2:13 pm
Relief to learn I am to use command line! thank you.
got it to work with
sqlcmd -S servername -d dbname -E -Q "SELECT * FROM [Schema].[dbo].[Inventory]" -s "," -o "\\address.org\vdifolders$\polkadot\Documents\US570333\Inventory.txt"
--Quote me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply