Thursday, November 20, 2008

search record from table at given date

you pass date as varchar type and mm/dd/yyyy format

select * from emp where (createddate>'11/15/2008' and

createddate<DATEADD(day,1, '11/15/2008'))

1 comment :

AJAX, asp, Asp.net, asp.net and sql server security, Asp.net IntemIndex, C#, Css, DataBinder.Eval, DataKeyNames, Datalist, Datapager, DataSet, DataTable, DropDownList, FindControl, gridview, JavaScript, jquery, Listview, Paging, Regex, RegularExpression, Repeater, Server side validation, Sql Server, timer, timercallback, Validation, XML, xmlnode, XPath