constraints should be the first option for enforcing data integr

來源: 撅著挺好 於 2009-08-24 20:49:14 [] [舊帖] [給我悄悄話] 閱讀數 : (314 bytes)
回答: 請教老土等高人, SQL Server Trigger 由 lookingback 於 2009-08-24 16:08:33

if it's not applicable, consider trigger.

I use trigger for auditing. trigger is often regarded by some people as source of pain && bottle neck of performance.

I'm ok with it.

For data retrieving, store procs is the first candidate for sure.

my 0.002 cents

thx 布衣~~

請您先登陸，再發跟帖！