SQL Server - TO COMPARE DATES PRESENT IN A TABLE WITH CURRENT_DATE

Asked By ali shaik on 16-Jul-12 03:35 AM

HI,

IN A CURSOR I WANT TO CHECK THE EXISTING DATES IN TABLE WITH CURRENT DATE????

Rohan Dave replied to ali shaik on 16-Jul-12 03:47 AM

you can do something like below..

Declare @CurrentDate DateTime
SET @CurrentDate = Convert(Date,getdate())

now in your cursor, check your existing data from table with "@CurrentDate" ..

Jitendra Faye replied to ali shaik on 16-Jul-12 09:33 AM

Use this command-

select * from tablename where getdate()= dateColName