Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76803 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / swathi
Queries are compiled each and evey time when we execute.
where as Stored Procedures are compiled only once when we
execute for the first time and the execution plans are
cached in memory.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is sql profiler. What are the default templates with it? : sql server database administration
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Describe in brief sql server monitoring ways.
How do I view views in sql server?
How to insert new line characters into strings?
What are rows and columns?
Explain how you can configure a running aggregate in SSRS?
What is the most common type of join?
What does indexation mean?
When you should use a low fill factor?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is the difference in accessing db between sql server vs sql azure?
What is multilevel indexing?
Explain about local stored procedure?
What are the difference between “where” and “having” clause in sql server?
