Solutions: 1) To remove the row count (“(139 rows affected)”) you should use SET NOCOUNT ON statement. See ref. 2) To remove column headers you should use -h parameter with value -1. See ref (section Formatting Options). Examples: C:\Users\sqlservr.exe>sqlcmd -S(local)\SQL2012 -d Test -E -h -1 -s, -W -Q “set nocount on; select * from dbo.Account” … Read more
I ended up using a slightly modified version of VDR’s solution which waits for the sqlservr to start by checking the logs instead of sleeping 10 seconds: RUN ( /opt/mssql/bin/sqlservr –accept-eula & ) | grep -q “Service Broker manager has started” \ && /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ‘P@ssw0rd’ -i /opt/mssql-scripts/000_create_db.sql \ && pkill … Read more
Just use -Q (uppercase). This command selects ‘asd’ and quits immediately: sqlcmd -S (local) -Q “select(‘asd’)”
sqlcmd -E -S SERVER\INSTANCE -Q “sp_databases” Notes: -E: Use a trusted connection (“Windows authentication”). Replace by -U username -P password for SQL Server authentication. -S SERVER\INSTANCE: The instance of SQL Server to which to connect. If you don’t know the name of your instance, you can use sqlcmd -L to get a list. -Q: The … Read more
(This one is going to sounds silly) my problem was that I wasn’t using capital ‘S’ Eg: C:\> SQLCMD -S localhost\sqlexpress
Use the -v switch to pass in variables. sqlcmd -v varMDF=”C:\dev\SAMPLE.mdf” varLDF=”C:\dev\SAMPLE_log.ldf” Then in your script file CREATE DATABASE [SAMPLE] ON PRIMARY ( NAME = N’SAMPLE’, FILENAME = N’$(varMDF)’ , SIZE = 23552KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N’SAMPLE_log’, FILENAME = N’$(varLDF)’ , SIZE = 29504KB , … Read more
I didn’t see all this info in once place and thought the next person looking for it might appreciate it… use the -h -1 option to remove the dashes (——–) from the output and SET NOCOUNT ON to remove the “rows affected”. This is great if you’re creating a report or CSV file for another … Read more
UPDATE I’ve now discovered that the if/else syntax above doesn’t work for me because some of my linked scripts require a GO statement. Essentially the :r just imports the scripts inline, so this becomes invalid sytax. If you need a GO statement in the linked scripts (as I do) then there isn’t any easy way … Read more
I’ve been working on this myself, and I can tell you it’s not easy. First, to address the reply by JT – you cannot dismiss “versions”, even with declarative updating mechanics that SSDT has. SSDT does a “pretty decent” job (provided you know all the switches and gotchas) of moving any source schema to any … Read more
In Management Studio, select the database, right-click and select Tasks->Export Data. There you will see options to export to different kinds of formats including CSV, Excel, etc. You can also run your query from the Query window and save the results to CSV.