Update Database column value on every month 1st date using Stored Procedure in SQL Server

Hi mahesh213,

Refer below query. If you are checking DateTime condition from code behind then remove IF condition from query.

SQL

CREATE PROCEDURE UpdateCount
AS
BEGIN
	IF (GETDATE() = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0))
	BEGIN
		UPDATE Employee SET [Count] = [Count] + 2
	END
END