Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between constraints and triggers?

Answer Posted / vampire007

I dont' think Triggers are performanc wise more superior to
constraints. Constraints are isolated to table level
whereas triggers are flexible to do the validation on any
number of tables.

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is dbcc?

978


What is Extended user-defined?

906


System variable and temporary variables

2197


What is meant by datasource?

883


Define union, union all, minus, intersect?

943


How to change the password of a login name in ms sql server?

976


Explain go command in sql server?

982


Explain what are the basic functions for master, msdb, model, tempdb databases?

929


Suggest a method of joining two tables.

1120


How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1157


What are acid properties of transaction?

908


What is difference between count (*) and count column?

852


What are the mathematical functions supported by sql server 2005?

1007


What are the components of sql server service broker?

959


What is provisioning, billing and metering, and connection routing concepts in the service layer?

113