Technical Article

Finding first/last day of month by a date

This script finds the first day of previous, current and next month as well as last day of previous, current and next month.The calculation is based on the ISO date format which makes it independant of the date format used on the SQL Server.The calculation is performed from a date - it can be altered […]

2004-12-02 (first published: )

225 reads

Blogs

Daily Coping 4 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQLServerCarpenter Tools

By

Over the past couple of years, I’ve developed several tools that I’ve been using...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

By

/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...

Read the latest Blogs

Forums

Combine tables with SQL in power bi

By pedroccamara

Hello everyone, i hope everyone is fantastic!! I've done some SQL queries in power...

CAST AS DATE Assistance

By carlton 84646

Can someone let me know why I'm not able to use CAST method to...

Deploying a standalone Azure VM running SQL Server into an availability zone

By DBANewbie

If i deploy a standalone Azure VM running SQL Server into an availavility zone;...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers