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