How to define a parameter to insert Date in SQL Server?

Hi,

You can apply Identity column on the column which has numeric data type like int, bigint etc....
and only one identity column possible with one table

If you are user of SQL 2012 that you can also use sequence please refer my article.

http://www.c-sharpcorner.com/UploadFile/ff2f08/sequence-in-sql-server-2012/

hope this will help you.

cmd.CommandText = "INSERT INTO person (birthdate) VALUES(@date)";             cmd.Parameters.Add(new SqlParameter("@date", dateTimePicker.Value.Date));             //con is sql connection             con.Open();             cmd.ExecuteNonQuery();             con.Close();



Either change the datatype to datetime and or pass only Date value to insert.

Hi,

It is not default value...

we cannot update the value of identity column.

Please refer below link to know more about identity column
https://technet.microsoft.com/en-us/library/aa933196(v=sql.80).aspx
http://www.sqlteam.com/article/understanding-identity-columns

hope this will help you.

Identity is used for auto increment value so no need to pass the value in this column SQL server automatic add incremental number in this column.

If you are user of SQL server 2008 and above so you can use DATE datatype to define birth date because in birth date we don't required time.

hope this will help you.