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 |
|
LacOniC
Starting Member
29 Posts |
 Posted - 2008-10-10 : 02:01:04
|
| Hi. I'm using SQL 2005. I set "Default Value or Binding" property of a column as "(getdate())". But i noticed some new records have "Null" value. What can be the problem? Any idea?Edit: Note: I don't use this column in any code, sp, trigger etc. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-10 : 02:19:42
|
| seems like they were updated explicitly to null value by some update operations. |
 |
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-10-10 : 02:38:15
|
| maybe you using the update |
|
|
|
LacOniC
Starting Member
29 Posts |
Posted - 2008-10-10 : 02:39:56
|
| Hmm. I didn't use column name in any update command but i found something like that in code: "opForm.dbRecordset.Update"Probably problem is that. Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-10 : 02:52:05
|
quote:
Originally posted by LacOniC
Hmm. I didn't use column name in any update command but i found something like that in code: "opForm.dbRecordset.Update"Probably problem is that. Thanks.
you can use profiler to trace if some update is happening on table column |
|
|
|
|
|
|
Default Value Problem