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

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2666

What are the types of joins in sql?

1055

What is Service Broker in sql server 2012?

970

How to delete a login name in ms sql server?

1004

How to write an inner join with the where clause in ms sql server?

1028

What are different types of subquery?

1180

How to drop existing indexes in ms sql server?

1014

What is a recursive stored procedure in sql server?

1086

Do I need a report server to run reports in my application?

153

How to select true false based on column value in sql server?

953

Can we create clustered index on composite key?

979

What is cdc in sql server?

951

What is primary key index?

919

How to change the system date and time from SQL Plus Terminal ?

1152

How can I know what locks are running on which resource?

898