Short Coding Snippet

Create Proc Usp_CheckStatus @id int As Begin Declare @status nvarchar(50) Set @status=(select status from TblUsers where id=@id)    If(@status='active')    Begin ---Your Block of Code/query   End End

SELECT DATEDIFF ( DAY , GETDATE (), GETDATE () + 1 ) AS DayDiff SELECT DATEDIFF ( MINUTE , GETDATE (), GETDATE () + 1 ) AS MinuteDiff SELECT DATEDIFF ( SECOND , GETDATE (), GETDATE () + 1 ) AS SecondDiff SELECT DATEDIFF ( WEEK , GETDATE (), GETDATE () + 1 ) AS WeekDiff SELECT DATEDIFF ( HOUR , GETDATE (), GETDATE () + 1 ) AS HourDiff

Next Month (select dateadd(m, 1, DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))) Next Month  + 1 (select dateadd(m, 2, DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)))