Thursday, 27 June 2013

Comparing Dates in sqlserver

DECLARE @Dt DATETIME

SET @Dt = GETDATE()
if (DATEPART(mm, @Dt)=2 and DATEPART(DD, @Dt)=26)
BEGIN
select * from tbl_Backup
END
else
begin
select * from tbl_MarkDetails
end

No comments:

Post a Comment