Set TextBox Readonly with jquery

$("#txtDemo").attr("readonly", true);

Select Day from Date in Sql Server

SELECT Day('2015-03-05 23:15:36.710')

-- Result: 5 

Select Month from Date in Sql Server

select MONTH('2015-03-05 23:15:36.710')

-- Result: 3 

Select Year from Date in Sql Server

SELECT YEAR('2015-03-05 23:15:36.710')

-- Result: 2015

Drop Down Data Binding in Asp.Net

DataTable data = GetData();

ddrLocationList.DataSource = data;

ddrLocationList.DataTextField = "Name";

ddrLocationList.DataValueField = "ID";

ddrLocationList.DataBind();

Get PI value in Sql Server

SELECT PI()

-- Result 3.14159265358979

Round values to N number of Decimal points in sql server

Round (expression , length)

SELECT ROUND(3.1415 , 2)        -- 3.14

SELECT ROUND(33.234234234 , 1)  -- 33.2

SELECT ROUND(55.6345345 , 0)    -- 56