Tag Archives: SQLNewBlogger

Using NULLIF–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the NULLIF() function recently, and I realized I’d never used it in code. It’s an interesting … Continue reading

Posted in Blog | Tagged , , | Comments Off on Using NULLIF–#SQLNewBlogger

Delaying Code Execution with Waitfor–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the rarely used commands for me is the WAITFOR command. This is a command that intentionally introduces … Continue reading

Posted in Blog | Tagged , , | Comments Off on Delaying Code Execution with Waitfor–#SQLNewBlogger

Using Framing for a Running Total–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve been writing about window functions, which I find very handy. In this post, I want to build a … Continue reading

Posted in Blog | Tagged , , | Comments Off on Using Framing for a Running Total–#SQLNewBlogger

Using Aggregates in Calculations with Other Columns Functions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In the last post on Window functions, I looked at ROW_NUMBER, and how I can use this to order … Continue reading

Posted in Blog | Tagged , , | 2 Comments