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

What are the 3 types of schema?

1041


What does executeupdate return?

927


What do you understand by physical_only option in dbcc checkdb?

933


What new changes are being made in SQL Server?

1098


Data table as parameter in sql server?

974


What is self contained sub query?

969


Why do we use trigger?

916


What is query parameter in ssrs?

143


What is normalization according to you and explain its different levels?

897


What happens if the update subquery returns no rows in ms sql server?

1073


What are the advantages of paper records?

907


What is partitioned view?

853


Can I run multiple instances of sql server 2000 at the same time on one computer?

1023


What is replication with database mirroring? : sql server database administration

986


What is extent? Types of extents?

1087