Monthly Archives: August 2013

Page Methods in ASP.NET

We cannot call the server side code directly into client side. The server side code will execute at server and client code at client. However by using some .Net techniques we can call server side code from JavaScript by using AJAX methods or ASP.NET AJAX Extensions. There are two ways to achieve this work one […]

Important Date Function In Sql Server 2008

Here are the some of important date function which i have worked out last week in order to write some Sp’s for my project. Start and End of Today SELECT DATEADD(DD,DATEDIFF(DD,0, GETDATE()),0) as [Start Of Day] DATEADD(s,-1,DATEADD(dd, DATEDIFF(dd,0,GETDATE())+1,0)) as [End Of Day] Start and End of Week SELECT DATEADD(WK, DATEDIFF(WK,0,GETDATE()),0) as [Start Of Week] DATEADD(s,-1,DATEADD(WK, […]