Most people know about cascading updates and deletes, but did you know there are two other foreign key constraint options you can use to maintain referential integrity?
Read all about them in
my latest article over at SQLTeam.com.
These features, introduced with SQL Server 2005, haven't got a lot of publicity, but they can be very useful. I just used the SET NULL option recently for the first time (inspiring me to put together an article on it) and it works great.
This entry was posted
on Wednesday, August 13th, 2008 at 6:56 am and is filed under Miscellaneous.
You can follow any responses to this entry through the RSS 2.0 feed.
Responses are currently closed, but you can trackback from your own site.
Medicamentspot.com International Legal RX Medications. Special Internet Prices (up to 40% off average US price). NO PRIOR PRESCRIPTION REQUIRED!…
Combivir@buy.online” rel=”nofollow”>.…
Buy:100% Pure Okinawan Coral Calcium.Actos.Prevacid.Arimidex.Petcam (Metacam) Oral Suspension.Accutane.Zovirax.Retin-A.Human Growth Hormone.Nexium.Prednisolone.Mega Hoodia.Zyban.Lumigan.Valtrex.Synthroid….
neon http://msatinfynd.BABYCLOTHESNUT.INFO/tag/neon+Hot+Pink/ : Pink…
Hot…
Buy:Actos.Zovirax.Mega Hoodia.Human Growth Hormone.Zyban.Valtrex.100% Pure Okinawan Coral Calcium.Synthroid.Retin-A.Nexium.Prednisolone.Lumigan.Prevacid.Arimidex.Petcam (Metacam) Oral Suspension.Accutane….
Buy:Petcam (Metacam) Oral Suspension.Zyban.Prevacid.Actos.Human Growth Hormone.100% Pure Okinawan Coral Calcium.Synthroid.Retin-A.Nexium.Valtrex.Accutane.Prednisolone.Arimidex.Mega Hoodia.Zovirax.Lumigan….