use [lin2db]
select * from user_account
where last_login > 2013-17-01
returns same record all over the time , no matter what date do I setup.
Shows ALL records from user_account not sorted by date
where last_login = 2013-17-01
where last_login < 2013-17-01
last_login > DATEADD(mm,-30,GETDATE())
Does`t give Returns at all
use [lin2db]
DELETE * from user_account
where last_login > DATEADD(mm,-30,GETDATE())
Incorrect syntax near '*'.