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

Recording Deleted Rows

Recently, we had a user delete a number of rows from a production database by mistake, it transpired …

Rich | Oct 4, 2021 | Sqlserver

Strings And Numbers

Something new happened this week, well not new in the sense like buying a new car but new to me, I …

Rich | Sep 27, 2021 | Sqlserver

How to Use Datediff

In this post, I want to take a look at datediff, how it works and how I use it as part of my job.

Rich | Sep 20, 2021 | Sqlserver

How to Use Dateadd

When I first starting learning T-SQL things like DATEADD took a really long time for my brain to …

Rich | Sep 13, 2021 | Sqlserver

Be careful when using Eomonth()

In SQL Server 2012 Microsoft added a function called EOMONTH, this returns the end of the month of …

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