Differences between functions and stored procedures?

Answer Posted / santhoshkumar.k

store procedure takes less time to execute the statement
than functions, also we can create loops inside the store
procedure.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the limitations in ssrs on sql server express edition?

158


Explain throw statement in sql server 2008?

734


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

694


How do database indexes work?

716


What do you understand by triggers?

685






How to modify an existing stored procedure in ms sql server?

737


How to override dml statements with triggers?

747


Explain different forms of normalization?

685


How do I shrink an ldf file?

731


What is star, snowflake and star flake schema? : sql server analysis services, ssas

856


What is table-valued sub query?

734


What is the difference between rank and dense_rank?

682


How to restore performance issues and how to check?

1708


What is log in sql server?

759


How to sort query output in descending order in ms sql server?

745