Tag Archives: T-SQL

Lengthen a Primary Key–#SQLNewBlogger

Posted on April 17, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed to increase the size of a PK and was getting a … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Upper Casing All the Data–#SQLNewBlogger

Posted on March 4, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a post recently where a user asked about needing to update all the data in all their … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Versions of Stored Procedures

Posted on February 6, 2019 by

I never knew this, but stored procedures have versions. I was browsing the CREATE PROCEDURE doc page, and stumbled upon this item. In the beginning part of a stored procedure definition, after the name, there is a section that starts … Continue reading →

Posted in Blog | Tagged , | 4 Comments

Careful with Session_Context()–#SQLNewBlogger

Posted on January 24, 2019 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. A quick note, which is more of a reminder to myself. I find writing things down helps me remember, … Continue reading →

Posted in Blog | Tagged , | 8 Comments