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

Call by value and call by reference in procedure and function, with NOCOPY.

1310

What is policy based management (pbm)? : sql server database administration

995

What do you do in data exploration

1000

What is inner join in sql server joins?

1046

What is log in sql server?

1155

When I delete any data from a table, does the sql server reduce the size of that table?

1028

Explain difference between cross join and full outer join?

1014

Is sql server is free?

986

Difference between aggregate functions of sql?

1110

what is dbcc? : Sql server database administration

1040

what are user defined datatypes and when you should go for them? : Sql server database administration

1028

What are sql server procedures?

992

How to create new tables with "select ... Into" statements in ms sql server?

998

SQL Server Architecture ?

2466

How do database indexes work?

1019