Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71782 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / senthil kumar
compared with query, stored procedure is efficient and fast
execution.Because stored procedure is program once it
formed then execute as a program.
| Is This Answer Correct ? | 90 Yes | 26 No |
Post New Answer View All Answers
What are the components of sql server service broker?
How to transfer data from a cursor to variables with a "fetch" statement?
What is the difference between deallocate cursor and close cursor?
What is row_number()?
What does normalization do to data?
Tell me what is the difference between locking and multi-versioning?
Explain trigger classes i.e. Instead of and after trigger?
What is index, cluster index and nonclustered index?
How to list all objects in a given schema?
What is self join in sql server joins?
Explain in details security in SQL azure?
How is table type constraint applied to a table?
What are the new data types are introduced in sql 2000?
What do you mean by data integrity?
Mention the differences between substr and charindex in sql server.
