Posted by jsfromynr on 10/31/05 11:40

Hi There,
You mustnot take getdate() as the default date as it will become
difficult /impossible to find which date is entered by User and which
one is not specified by the user . You must provide constant in default
constraint not anything that keeps on changing .
Alter Table ourTable Add X int Default Cast(rand()*10 as Int) ---
Completly Wrong because different values will be assigned .
Similary
Alter Table ourTable Add X1 datetime Default getdate() --- Completly
Wrong because different values will be assigned .

With Warm regards
Jatinder Singh

[Back to original message]