Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77468 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
Why do we partition data?
What is page-level compression?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What encryption security is available in sql azure?
How to create a view using data from another view?
What are secondary xml indexes?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the difference between locking and multi-versioning?
What is a deadlock and what is a live lock?
What is the maximum row of a size?
Does union all remove duplicates?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is the difference between functions and scalar functions?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
