Set Hidden Field value in Jquery

$("#hdTest").val("MyValue");

Make Button visible in jquery

$("#btnTest").show();

Hide button with jquery

$("#btnTest").hide();

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