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

What is normalization of database? What are its benefits?

1070

what exactly sql injuction.how to overcome.....

2595

Do you have any idea about the tcl commands?

1013

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

How to add a new dsn with the odbc driver for sql server?

1112

What's new in sql management studio for sql server? : sql server management studio

1119

Can sql servers linked to other servers?

1095

What does truncate do?

993

What is normalization? What number of normalization shapes are there?

1155

What is tablix?

169

What is the difference between dropping a database and taking a database offline?

1218

Can you explain what are commit and rollback in sql?

986

Explain throw statement in sql server 2008?

1054

What are the source of constraints?

978

when would you go for denormalization? : Sql server database administration

911