A reader asked how to pass a different table name each time in SSMS. I show how to set and use a variable in SQLCMD mode with :SETVAR, step by step.
SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050
SQL in Sixty Seconds hits its 50th episode and a full hour of play time. To celebrate, get a free SQL Server Interview Questions and Answers sample chapter.
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
Old server names clutter the SSMS Connect dialog. This SQL in Sixty Seconds video shows how to remove cached login entries in SQL Server 2012 and earlier.
SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048
Enable SQLCMD mode in SSMS and use sqlcmd right inside SQL Server Management Studio, for example to switch between servers in one script.
SQL SERVER – Exporting Query Results to CSV using SQLCMD
A reader on Facebook asked how to export query results to CSV using SQLCMD. It is a very simple command, and I show it with an AdventureWorks2012 example.
SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD
Good DBAs automate the boring work. Here is a simple script to run Backup and Restore of a database from the command prompt with SQLCMD.
SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL
Visual Studio says connections to .mdf files require SQL Server Express 2005? You do not need 2005. Point Data Connections to your installed instance name.