Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72612 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
Is sql server free?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What are the different types of triggers in SQL SERVER?
Mention the differences between local and global temporary tables.
What is the difference between locking and multi-versioning?
What is acid properties?
Can you leave a union at any time?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is inline table-value user-defined function?
What are information schema views?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is correlated subquery in sql server?
What is a deadlock and what is a live lock?
What does REVERT do in SQL Server 2005?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
