Difference between Triggers and Stored Procedure
- 23 Answers
- 67003 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / gangi naidu.k
In case of sql queries,it is possible to compile one query
at a time,but incase of stored procedure we can compile
bunch of queries at a time and also it is need at first
time only,suppose we need modification on queries,after
modifications no need to compile again in case of stored
procedures,but in case of sql queries we have to compile
every time.Stored procedure contain queries in compiled
format so execution also fast and tome saving.One more
thing is in case of stored procedures serurity also more.
| Is This Answer Correct ? | 18 Yes | 15 No |
Post New Answer View All Answers
what is a correlated sub-query? : Sql server database administration
How to update a field in SQL after ALTERING a row?
What is the standby server?
List types of tables in SQL Azure?
what is a deadlock? : Sql server database administration
What is a performance monitor?
How can a database be repaired?
What is bulkcopy in sql?
Can a database be shrunk with users active?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
optimization techinques
How to count groups returned with the group by clause in ms sql server?
What does it mean to invest in the index?
Explain trigger and its types?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
