Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71781 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / ashwini
SQL query will be compiled everytime it is executed.
Stored procedures are compiled only once when they are
executed for the first time.
| Is This Answer Correct ? | 209 Yes | 18 No |
Post New Answer View All Answers
Why de-normalization required?
Do you know what is user defined datatypes and when you should go for them?
What is a mutating table error and how can you get around it?
How to use group functions in the select clause in ms sql server?
Tell me what is the order in which the sql query is executed?
How to provide values to stored procedure parameters in ms sql server?
How to list all user defined functions in the current database?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is 'write-ahead log' in sql server 2000 ?
What is sql server agent and what are the two modes of authentication in sql server?
How to download and install microsoft .net framework version 2.0?
How do you Implement SSIS Packages in your Project?
how many triggers you can have on a table? : Sql server database administration
What is self contained multi valued query?
How can I create a report based on a query? : sql server management studio
