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 is the concept of optimization?

681


What is transaction server distributed transaction?

633


Tell me what is difference between view and materialized view?

602


How to find the login name linked to a given user name?

607


What are window functions in sql server?

595






Name three of the features managed by the surface area configuration tool? : sql server security

597


what are the disadvantages of cursors? : Sql server database administration

591


Why SQL Agent is used?

684


What are temporal tables in sql server 2016?

560


What are the advantages of passing name-value pairs as parameters?

741


What Is Rdbms?

750


What is the difference between clustered index and primary key?

589


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

681


Explain encryption of entire databases without the need for application changes in sql server 2008?

666


What do you understand by the data quality services in sql server?

582