Difference between Triggers and Stored Procedure
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 master database? : SQL Server Architecture
What is partition, how will you implement it? : sql server analysis services, ssas
what is the difference between Delete and Truncate command in SQL
What functions can a view be used to performed?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What have included columns when we talk about sql server indexing?
What is page in sql server?
How to receive output values from stored procedures?
Explain multiserver query
What is the stored procedure?
How secure is sql server database?
What are the different types of backups avaialabe in sql server 2005?
Ms sql server index?
How can you insert values in multiple rows using one Insert statement?
Explain the steps to use transact-sql cursor?