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


Microsoft industry clouds


In talking with Microsoft customers, I have found that most are not aware that...

Two Clustered Indexes?


Everyone knows that you only get a single clustered index, right? Wouldn’t it be...

Daily Coping 18 Jan 2022


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

Read the latest Blogs


Setting a variable from a multi-table Select

By JaybeeSQL

Hi all, I have a variable to declare, and this works: Declare @CopyFromUser Varchar(10)...

Deploying Dacpacs?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deploying Dacpacs?

How to practice OOP in C++ effectively?

By TembaBavuma

I am currently writing a desktop application with Qt and C++. While I have...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers