Delte_Data& Shedule SP

Dec 13 2012 8:34 AM

Hi,

Create a store procedure to delete the data from table, the rule is, look for date, if it is before 12 months delete that row.We need to schedule this Sp weekly or monthly

Please let me know what query should i write for this....

Answers (1)

select * from table where 3 > 2 what will return this query? anyone explain this query??

error while attaching mdf fle to sql server 2008 management studo