Difference between Triggers and Stored Procedure
Answer Posted / ram
Stored Procedures are called by the programmer wherever it
wants to fire but triggers fired automatically when
insert,delete,update occured. And triggers can be
implemented to tables & views only where as s.p used in the
database independently
| Is This Answer Correct ? | 135 Yes | 13 No |
Post New Answer View All Answers
What do you mean by an execution plan? Why is it used? How would you view it?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is an index. What are the types?
How many replicas are maintained for each SQL Azure database?
What is inline variable assignment?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Do you know nested transaction?
What are the aggregate and scalar functions?
What is log in sql server?
How you can move data or databases between servers and databases in sql server?
Are resultset updatable?
Explain cross join or cartesian product in sql?
What is it unwise to create wide clustered index keys?
which backup strategy you are following at ur company
How to turn on the mssql api module in php?