• SQL Theater
  • Blog

Using the Same Column Twice in a SQL UPDATE Statement

September 13, 2018
Doug Lane
Coding, T-SQL
3 Comments
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…
Read More

T-SQL Tuesday #96: Three Pivot Points

November 14, 2017
Doug Lane
Career
T-SQL Tuesday
1 Comment
T-SQL Tuesday is a monthly blog series made up of community contributions. This month’s topic is “Folks Who Have Made a Difference”, by Ewald Cress. This month’s T-SQL Tuesday is an…
Read More

Why You Can’t Use ROW_NUMBER() In Your WHERE Clause

September 28, 2017
Doug Lane
T-SQL
Here’s a common coding scenario for SQL Server developers: “I want to see the oldest amount due for each account, along with the account number and due date, ordered by…
Read More

Three Magic Letters to Make Your DBA Like You More

September 21, 2017
Doug Lane
T-SQL
Database Administrators are a finicky bunch. They fret over fine details and fuss over imperfections in our code. It’s not that they obsess over these things because they enjoy it.…
Read More

Stop Using PRINT to Track Query Progress

September 12, 2017
Doug Lane
Coding, T-SQL
1 Comment
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…
Read More
1 2 3 Next

Recent Posts

  • Using the Same Column Twice in a SQL UPDATE Statement September 13, 2018
  • T-SQL Tuesday #96: Three Pivot Points November 14, 2017
  • Why You Can’t Use ROW_NUMBER() In Your WHERE Clause September 28, 2017
  • Three Magic Letters to Make Your DBA Like You More September 21, 2017
  • Stop Using PRINT to Track Query Progress September 12, 2017

Categories

  • Career (4)
  • Coding (3)
  • Public Speaking (2)
  • T-SQL (5)
  • Video Production (1)

Tags

Interviewing Jobs T-SQL Tuesday

© Copyright 2016-2017 SQL Theater, LLC