Press "Enter" to skip to content

Optional String Quotes in Stored Procedures

Dualcore DBA learns something new:

Today’s post is a quick one and the first in a new series I am calling “I Was Today Years Old When…” where I share simple little nuggets that I stumbled across where I think “How…HOW have I never known this”

The series for me will serve as a reminder as to why I love working with technology – even if you are working with something you have worked with for many years, every day is a school day, even if the day’s lesson is a small one.

The first “I was today years old when…” is in relation to stored procedure calls in SQL Server.

Click through for the example. Admittedly, I didn’t know this either. Also admittedly, I’m going to go back to forgetting so that I don’t actually use this.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.