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

What is the difference between constraints and triggers?

Answer Posted / vampire007

I dont' think Triggers are performanc wise more superior to
constraints. Constraints are isolated to table level
whereas triggers are flexible to do the validation on any
number of tables.

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by sql server agent?

1026


What is perspective, have you ever created perspective? : sql server analysis services, ssas

962


Explain Geography datatype in SQL Server

1192


Explain the commands in sql server?

1098


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2630


Explain steps of normalization?

1065


What have included columns when we talk about sql server indexing?

1078


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1122


Explain system scalar functions?

1044


Can the “if update (colname)” statement be used in a delete trigger?

1034


What are the pre-defined functions in the sql server?

1185


on line cluster can we make if yes tell me the procedure

2067


Why use sub query in sql server and list out types of sub queries?

1055


how many layers of tcp/ip protocol combined of? : Sql server database administration

1049


What do you mean by tablesample?

1124