Friday, February 25, 2011

All About Date Time in sql server

http://www.databasejournal.com/features/mssql/article.php/2191631/Working-with-SQL-Server-DateTime-Variables.htm

Good link for all about datetime in sql server

Get Starting of Current Week, Current Month, Current Year in Sql Server

declare @CurrentWeek date, @CurrentMonth date, @Year date, @LastWeek date, @LastMonth date, @LastYear date
Declare @DateValue DateTime = '3/24/2011'
select @CurrentWeek = DATEADD (wk, datediff( wk, 6, @DateValue ), 6 )
select @LastWeek = DATEADD(Wk, -1, (@CurrentWeek))

select @CurrentMonth = CONVERT(date, CONVERT(varchar, DatePart (M, @DateValue)) + '/1/' + convert(varchar, DATEPART(YEAR,@DateValue)))
select @LastMonth = CONVERT(date, DATEADD(M,-1 , @CurrentMonth), 106)

select @Year = CONVERT(date, CONVERT(varchar, '1/1/' + convert(varchar,DATEPART(YEAR,@DateValue))))
select @LastYear = CONVERT(date,DATEADD(YEAR, -1,@Year),106)

select @CurrentWeek,@LastWeek,@CurrentMonth,@LastMonth, @Year, @LastYear


Wednesday, November 3, 2010

SharePoint 2010 installation guide

Nice link for reference

http://mosshowto.blogspot.com/2009/11/installing-sharepoint-2010-windows-2008.html

Thursday, September 9, 2010

To fetch tables having records in db

select * from sys.objects where object_id in (
select id from sysindexes where indid <2>0 )
and type ='U'

Friday, August 20, 2010

Partial PostBack animations handeled at Clientside

var postbackElement;
Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginRequest);
Sys.WebForms.PageRequestManager.getInstance().add_pageLoading(PageLoading);
Sys.WebForms.PageRequestManager.getInstance().add_pageLoaded(pageLoaded);

function beginRequest(sender, args) {
postbackElement = args.get_postBackElement();
}

function PageLoading(sender, args)
{
var ShowDiv = document.getElementById("dv" + divID);
if(ShowDiv != null)
{
$(ShowDiv).fadeOut();
}
}
function pageLoaded(sender, args) {

var ShowDiv = document.getElementById("dv" + divID);
if (typeof(postbackElement) === "undefined") {
return;
}
else if (postbackElement.id.toLowerCase().indexOf('cancel') > -1) {
$(ShowDiv).fadeIn();
}

}