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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table?

Question Posted / guest

Answer Posted / guest

Constraint is better in terms of performance for same
operation. Why??

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can a table be moved to different filegroup? : Sql server administration

962

How to test subquery results with the exists operator?

1095

Explain what are commit and rollback in sql?

923

What are system databases into sql server (2005/2008)?

993

What is buffer cash in sql server?

1148

Do you know sql server 2008 introduces automatic auditing?

972

How to write character string constants or literals in ms sql server?

1008

Can we shrink data file in sql server?

1037

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

976

What is left outer join in sql server joins?

1029

Do you know how to send email from database?

989

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1063

How to create a view with data from multiple tables?

1008

Explain what is it unwise to create wide clustered index keys?

973

What is ms sql server service broker?

980