how to insert the month_year into sql server from textbox?

Posted by Tejamanimala under ASP.NET on 10/18/2013 | Points: 10 | Views : 896 | Status : [Member] | Replies : 1
hi,i want to insert only month_year into sql server from textbox.

i have one textbox,and submit button when i enter the only month and year into textbox,then that month_year should be store into payroll table,which is having Month_Year column,can any one tell me ?

manimala


Responses

Posted by: Bandi on: 10/18/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
I think no need to have separate Month_Year column.....
Do you have any DATETIME column in the table...?

Refer this link for getting the MM-YYYY format of the DATETIME column in SQL Server
http://www.sql-server-helper.com/sql-server-2008/sql-server-2008-date-format.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response