Difference between Triggers and Stored Procedure
- 23 Answers
- 69422 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 mapping schema?
How to create a new schema in a database?
How to list all objects in a given schema?
What happens if you delete a table that is used by a view?
What is data file in computer?
What is policy based management (pbm)? : sql server database administration
What is meant by indexing files?
What is data source object?
What are indexers?
What functions can a view be used to performed?
How to convert a numeric expression from one data type to another?
What is the native system stored procedure to execute a command against all databases?
Call by value and call by reference in procedure and function, with NOCOPY.
What is the log shipping?
Explain the rules for designing files and file groups in sql server?
