Using the Same Column Twice in a SQL UPDATE Statement
An application developer came to me with this question recently: “Can I use the same column twice in a SQL UPDATE statement?” Yes and no. It depends on what you…
Coding
Stop Using PRINT to Track Query Progress
For years, I relied on using PRINT in my T-SQL to give me updates on my script’s progress in SQL Server Management Studio. After each major statement, I’d throw in…
10 Essential Skills for SQL Server Beginners
Jesse Seymour recently asked this question on Twitter: Hey #sqlfamily, need some research help 🙂 Your opinion, top ten skills to master for entry level MS BI pro? Could be…