What is difference between Triggers and store procedure?
- 2 Answers
- 4910 Views
- I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Why use “in” clause in sql server?
How many joins in sql server?
How do I start sql server agent automatically?
How to test values returned by a subquery with the in operator?
What are the new data types are introduced in sql 2000?
What are different types of join?
What do you mean by tablesample?
Explain about sql server login?
Explain nested trigger in sql?
What is the significance of null value and why should we avoid permitting null values?
Define views.
How to use old values to define new values in update statements in ms sql server?
What are the advantages of using stored procedures in sql server?
Explain unique key in sql server?
What is set nocount on and what is set nocount off?
