Tag Archives: SQLNewBlogger

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 , , | Leave a comment

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 , | Leave a comment

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 , , | Leave a comment

Using a Regular Expression to Detect a Number–#SQLNewBlogger

Posted on June 15, 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 had a customer recently that was looking to work with Data … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using a Regular Expression to Detect a Number–#SQLNewBlogger