dwain.c (10/1/2012)

---

sqlusers (10/1/2012)

---

Hi Guys,

I have created a Default Constraint for my table. But this is not reflected on my table.

EX: Column ImportDate has a Datetime Datatype with NOT NULL Constraint.

I have created a Default Constranit for this as GETDATE(). But while checking the query this Constraint not getting reflected on my table.

Every time it shows NULL.

Can any one help on this?

Could it be that you are looking at records that were created before you added the DEFAULT constraint?