SQL Server Forums - DEFAULT CONSTRAINT not working

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

DEFAULT CONSTRAINT not working

New Topic

Reply to Topic

Printer Friendly

Author

Topic

yosiasz
Flowing Fount of Yak Knowledge

USA
1608 Posts

Posted - 02/22/2013 : 20:41:25

Greetings

Ever come across this? I created a default constraint on ModifyDate and ModifyBy
When doing an update on a row the values of these column do not change. They are both nullable columns, it is something I have inherited and am unable to change the embedded oogly code on the site.

Not sure why the constraint are not doind what I was hoping to do when site calls UPDATE table set x = 0
Thanks

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts

Posted - 02/22/2013 : 20:48:13

default constraint only take effect on INSERT statement. Not UPDATE

KH
Time is always against us

yosiasz
Flowing Fount of Yak Knowledge

USA
1608 Posts

Posted - 02/22/2013 : 20:51:17

are you serious!!!!!!?!? u learn something new all the time.

THanks Khtan!

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts

Posted - 02/22/2013 : 21:02:05

http://msdn.microsoft.com/en-us/library/aa175912%28v=sql.80%29.aspx

if you want to handle the UPDATE, you need to use update trigger

KH
Time is always against us

Edited by - khtan on 02/22/2013 21:03:02

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.