A quick trick from a Virtual Tech Days demo: adding a string to GETDATE() throws an error. CAST fixes it, and SQL Server 2012 CONCAT does it more simply.
SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring
I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Windows Authentication by SQLCMD uses the current Windows identity with -E. It does not need a Windows password in the command.
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
Turn on SQLCMD Mode and the SSMS Query Editor can run sqlcmd scripts that mix OS and SQL commands. The interesting part: the OS commands run first.