Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MaSe
Starting Member
8 Posts |
 Posted - 2005-11-21 : 08:36:41
|
| I have in mssql a column where i want the date of the day that it has bin made.I am using this in a ms access forum where i create contracs.And when a contract is created, i want to have in the column the date that it was created.Can you set it as default Value ?Or must i do it whit a Trigger or Stored Procedure ? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-21 : 08:39:29
|
| You can set the default value as GetDate()or In your Insert statement use GetDate() to insert value to that columnMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Column DateNow...