Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76931 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 is bcp? When does it use?
What do you mean by normalisation?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain few examples of stored procedure over triggers?
How can you list all the table constraints in a database?
What is trigger and different types of Triggers?
What is read uncmmited?
What is the filtered index?
When does a workload on SQL Azure get throttled?
What are binary string data types in ms sql server?
What is a transact-sql statement?
How can we migrate from SQL server to SQL Azure?
How do you create type- insensitive operator?
Explain the rules for designing files and file groups in sql server?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
