Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shashi kishor prasad
1.Stored Procedures are Pre-compiled functions that needs to
be called but Triggers are event driven and can't be called
explicitly like stored procedures
2.Stored procedures can take arguments but Triggers dont
take arguments.
3.Stored procedures cant get executed unless they are called
by by the calling program but Triggers gets fired as soon as
an event for which it has been created takes place.
4. Stored procedures can work on the database and values it
has been assigned but Triggers can work on db other than that.
5.Stored Procedures are used to make the execution faster
and to prevent from sql injections to some extent but
Triggers are used to achieve different tasks on occurrence
of an event like insert update and delete on a table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is tablesample?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to transfer data from a cursor to variables with a "fetch" statement?
What is #table in sql server?
Explain trigger classes i.e. Instead of and after trigger?
How sql server enhances scalability of the database system?
Explain the creation and execution of a user-defined function in the sql server?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Tell me something about security and sql azure?
What is difference between unique and primary key?
Give a example to search fr a string in all stored procedure in sql server.
How to add a new dsn with the odbc driver for sql server?
What is a partition function in sql server?
What method is used by the Command classes to execute SQL statements that return single values?
Define normalisation?
