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

Explain Geography datatype in SQL Server

1107

How to write a query with a full outer join in ms sql server?

1053

Determine when an index is appropriate?

1053

Explain error and transaction handling in sql server?

990

Explain stored procedure?

1027

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1018

Why truncate is ddl command?

1039

What is a transact-sql statement batch in ms sql server?

995

What is the difference between Stored Procedures and triggers?

1066

How do I open port 1433?

916

What does ss stand for sexually?

1061

What does it mean to normalize data?

921

Can primary key be null?

913

where the connection string store in the database

2050

How to set database to be single_user in ms sql server?

1007