Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71775 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / gayathri
Every query is submited it will be compiled & then
executed.where as stored procedure is compiled
when it is submitted for the first time and this compiled
content is stored in something called procedure cache,
for subsequent calls no compilation,just execution & hence
better performance than query.
In Query we can execute only 1 statement. Stored Procedure:
In Stored Procedure we can execute Batch of Queries
| Is This Answer Correct ? | 103 Yes | 11 No |
Post New Answer View All Answers
What are functions in the sql server?
Explain about SQL server 2005?
What function does a database engine serve in the sql server?
What are the new features are introduced in sql server 2012 reporting services?
What is the difference between createstatement and preparedstatement?
What is the purpose of the master database?
What is difference statement and preparedstatement?
What are the differences between clustered and non-clustered index?
Tell me the difference between clustered and non-clustered index?
Why do we need normalization?
What is the difference between SQL notification and SQL invalidation?
When a primary key constraint is included in a table, what other constraints does this imply?
What are constraints?
How to test odbc dsn connection settings?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
