Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76951 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
explain what is raid and what are different types of raid configurations? : Sql server database administration
Mention the different types of triggers?
Do you know nested transaction?
State a few properties of relational databases?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How do I find the default sql server instance?
How to convert binary strings into integers in ms sql server?
How can you find out how many rows returned in a cursor?
What is the difference between TRUNCATE and DROP?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is always encrypted?
Do you know what are the ways available in sql server to execute sql statements?
How to change the name of a database user?
How do you identify a foreign key?
