Tag Archives: SQLNewBlogger

An Update to Skipping the Leading Digit in T-SQL–#SQLNewBlogger

Posted on October 17, 2022 by way0utwest

There was an interesting question in a forum, which I wrote about before. How do you skip the leading digit in a numeric value. I had looked at a UNION, but someone had a better suggestion, so I’m adding to … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Checking Database Compatability = #SQLNewBlogger

Posted on September 21, 2022 by way0utwest

Recently I needed to check the compatibility level of a database and SSMS didn’t work. This is what I did in T-SQL.https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 Another post for me that is simple and hopefully serves as an example for people trying to get … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Checking Database Compatability = #SQLNewBlogger

Replacing NULLs in a Left Join–#SQLNewBlogger

Posted on September 7, 2022 by way0utwest

I saw someone ask a question on how to replace NULL in a left join and decided to write a post. I realized this is one of those simple things that people new to SQL might not get. Another post … Continue reading →

Posted in Blog | Tagged , | Comments Off on Replacing NULLs in a Left Join–#SQLNewBlogger

Import a CSV with a Header Row using BCP–#SQLNewBlogger

Posted on August 22, 2022 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. I was demoing something recently and needed to show someone how to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Import a CSV with a Header Row using BCP–#SQLNewBlogger