Difference between writing SQL query and stored procedure ?
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
How to transfer data from a cursor to variables with a "fetch" statement?
How to use go command in "sqlcmd"?
What is the difference between commit and rollback?
What is the difference between clustered and a non-clustered index?
What are the grouping functions?
What stored by the tempdb ? : sql server database administration
What command would you use to create an index?
How to disable triggers using "disable trigger"?
What is sql server replication? : sql server replication
Does sql server 2000 full-text search support clustering?
How do I edit a stored procedure in sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
what is a self join? Explain it with an example? : Sql server database administration
What are the different subsets of sql?
What is a field in a table?