Hi...
I want to know how can we find out last seven day article record from c#corner side. please define with query form in sqlserver.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kunal VaishyaPosted Jul 16, 2012, 6:08 AM
Do like this
Select Article From ArticleTable Where Postdate > DateAdd(Day,-7,getdate()) and PostDate <= Getdate()