Difference between writing SQL query and stored procedure ?
Answer Posted / komal sankhe
compared with sql query, stored procedure is efficient and
timesaving execution.Because stored procedure is program
once it formed then execute as a program at the same
time.coz queries are taking the time
| Is This Answer Correct ? | 19 Yes | 22 No |
Post New Answer View All Answers
what's the maximum size of a row? : Sql server database administration
What is an index. What are the types?
What is a trigger in sql server?
Explain “row_number()” in sql server with an example?
Why Master database is required?
How to delete duplicate rows in sql server?
What is difference between standardization and normalization?
What is difference between delete and truncate commands?
What the different components in replication and what is their use?
What is query cost in sql server?
What is tempdb in sql server?
What is the native system stored procedure to execute a command against all databases?
Explain the xml support sql server extends?
What is the server name for sql management studio?
How to skip remaining statements in a loop block using continue statements?