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.
What about creating a startup script with SET NOCOUNT ON in the script (assign the script to the SQLCMDINI environment variable). http://msdn.microsoft.com/en-us/library/ms162773.aspx
Open a command prompt window. If you have a default instance of SQL Server already running, run the following command on the command prompt to stop the SQL Server service: net stop mssqlserver Now go to the directory where SQL server is installed. The directory can for instance be one of these: C:\Program Files\Microsoft SQL … Read more
You can run something like this: sqlcmd -S MyServer -d myDB -E -Q “select col1, col2, col3 from SomeTable” -o “MyData.csv” -h-1 -s”,” -w 700 -h-1 removes column name headers from the result -s”,” sets the column seperator to , -w 700 sets the row width to 700 chars (this will need to be as … Read more