Date Missing Procedures

Posted by Senthilmcatyr under Sql Server on 8/24/2011 | Points: 10 | Views : 1287 | Status : [Member] | Replies : 2
I create table and and these columns are PartID, Date and etc..... I need create procedures. When i execute this procedures automatically missing dates insert in these tables. how is possible. Is possible pls send.


Regards,
SenthilKumar.S




Responses

Posted by: Nithadeepak on: 8/24/2011 [Member] Bronze | Points: 25

Up
0
Down
Hi Senthil,

You can give DEFAULT constraint to the date column.

http://stackoverflow.com/questions/2095289/sql-server-alter-column-adding-default-constraint

Nitha Deepak

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

Posted by: Nithadeepak on: 8/24/2011 [Member] Bronze | Points: 25

Up
0
Down
Refer this...
http://www.w3schools.com/sql/sql_default.asp

Nitha Deepak

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

Login to post response