Tag Archives: T-SQL

Basic JSON Queries–#SQLNewBlogger

Posted on November 30, 2020 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I saw Jason Horner do a presentation on JSON at a user group meeting. I’ve lightly looked at … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Strange T-SQL Operator Syntax

Posted on November 9, 2020 by way0utwest

I can’t remember where I saw this, but it made an interesting Question of the Day: select * from Sales where Profit !< 10000; I had never seen anything like this, in all my years of working in C, C++, … Continue reading →

Posted in Blog | Tagged , | Comments Off on Strange T-SQL Operator Syntax

Adding a Check Constraint to a Table–#SQLNewBlogger

Posted on October 20, 2020 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had to do this the other day, and while I guessed at the syntax, I wasn’t sure of … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding a Check Constraint to a Table–#SQLNewBlogger

Cleaning up bad dates–#SQLNewBlogger

Posted on September 23, 2020 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got some data recently from an online service, MapMyRun.com, where I track my workout data. I’ve been doing … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Cleaning up bad dates–#SQLNewBlogger