Tag Archives: T-SQL

Getting Parameters Out From a Stored Procedure–#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 lesser used and known features of T-SQL are the output parameters from a stored procedure. I … Continue reading

Posted in Blog | Tagged , , | 5 Comments

Sorting Values in a Column

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This was a post that caught my eye, since I’d just written a piece on STRING_SPLIT(). Someone had this … Continue reading

Posted in Blog | Tagged , ,

Testing SQL in the Advent of Code

I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in the way. Still, trying to solve some programming challenges is a good way of practicing your skills. If you’re competitive, … Continue reading

Posted in Blog | Tagged , , , ,

Identity Gaps–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Many people think that that an identity property will ensure a consistent, increasing numerical value. I ran across this … Continue reading

Posted in Blog | Tagged , , | 6 Comments