Rich Howell | SQL Server Developer & Data Wrangler
  • Home
  • Blog
  • Training
  • Resources
    Projects Scripts Dates T-SQL Reference Books We Recommend
  • About
  • Contact

Clarion Date Time To SQL DateTime

Clairon date is the number of days that have elapsed since December 28, 1800, in SQL Server this …

Rich | Nov 8, 2021 | Sqlserver

[Video] Inner Joins In Microsoft SQL Server

In this post we are going to take a look at Inner Joins, what they are and how they work.

Rich | Nov 1, 2021 | Sqlserver

[Video] Left Joins In Microsoft SQL Server

In this post we are going to take a look at Left Joins, what they are and how they work.

Rich | Oct 25, 2021 | Sqlserver

What are CTEs & How Do They Work?

A CTE or Common Table Expression specifies a tempoary named result set for the current session, a …

Rich | Oct 18, 2021 | Sqlserver

Removing Duplicate Rows with ROW_NUMBER()

Sometimes you will come across a dataset that contains two or more rows of the same data, in a data …

Rich | Oct 11, 2021 | Sqlserver
  • 5
  • 6
  • 7
  • 8
  • 9
© Rich In SQL 2023. Built with Hugo, Hosted on Netlify