Interested to Buy Any Domain ? << Click Here >> for more details...
about triggers?
- 6 Answers
- 7323 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anuj
Triggers are special type of procedure which execute based
on events like insert a new row into table or delete or
update the table.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / balaji karpurapu
Trigger is a special kind of stored procedures,
Triggers are executed at the time of even takes
INSERT,UPDATE,DELETE actions.
1)Triggers are executed by attaching with table or view
2)Triggers are not stand alone executable
Triggers are classified into three types
1)DML Triggers
2)DDL Triggers
3)CLR Triggers
Syntax:
CREATE TRIGGER TRIGGER_NAME
ON TABLE/VIEW NAME
AFTER/INSTEAD OF
AS
BEGIN
---------
END
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / raj
this special kind of stored procedure,this is triggered
while insert, delete,update
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / riju
Triggers are like auto executable store procedures.Triggers
can be execute before or after any DDL or DML statements.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / arun kumar
trigger is proggramed procedures
with the help of trigger we can insert, delte, update data
from two tables
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between STA and MTA?
What happens when you encounter a continue statement inside the for loop ?
what is more complex to implement property, methods or event? how can I define criteria to compare the difficulty of implementation between them? for example the number of methods wanted to implements property is 2 methods. how many methods I need it to implements events?
How to Insert a TextBox value in to Sql database using C#.Net coding
List the new features added in .net framework 4.0.
what is conceptual model?
Difference between .NET & J2EE
How do you box a primitive data type variable ?
What is Peek method in Tempdata in ASP.Net MVC?
What is .net framwork?
What is the .net framework?
how do you query in entity model when the result has a join from from different database other than the entity model?
Dot Net Framework 
