Get current system date in Sql Server

SELECT GETDATE()

-- Result : 2014-03-23 19:57:21.630

Find Version of Sql Server through query

select @@Version

Result from My Computer:

--Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

--Feb 10 2012 19:39:15

--Copyright (c) Microsoft Corporation

--Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

Reverse values with Reverse function in Sql Server

select REVERSE(45)  -- Result 54

select REVERSE('abc') -- Result cba

Select Last Date of Current year in Sql Server

SELECT DATEADD(yy, DATEDIFF(yy, 0, getdate()) + 1, -1) AS LastDateOfYear

Select First Date of Current year in Sql Server

SELECT DATEADD( yy, DATEDIFF( yy, 0, getdate() ), 0) AS FirstDateOfYear

#region in Visual Studio

It allows block of code to expand or collapse when using the outlining feature of the Visual Studio Code Editor. You can write namespaces, classes, methods, interfaces, delegates, events inside it.

#region MyRegion

//  Namespaces

//  Classes

//  Methods

//  Interfaces

//  Delegates

//  Events

#endregion

Page Pre_Render Event in Asp.net C#

If you want to perform some action after the page is completely loaded and Ready to Render then the desired code should be written in this event.

protected void Page_PreRender(object sender, EventArgs e)

{

    // Your Code Goes Here

}