Difference between Function and Stored Procedure?

Answer Posted / sreyasmn

1. Function must returned a value,but stored procedure is
not necessorly returned value

2. A function can be used to calculations,but sp used to
solve a business logic

Is This Answer Correct ?    36 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the command used to rename the database.

536


What is difference between group by and having?

566


What are the differences between left join and inner join in sql server?

591


What is normalization and its types?

542


Describe and explain about SQL native client?

622






What are relationships and mention different types of relationships in the dbms

565


how many bits ip address consist of? : Sql server database administration

466


Does a server store data?

504


Write a SQL queries on Self Join and Inner Join.

621


What are the purposes and advantages stored procedure?

501


What is tablix?

115


What is repeatable read?

542


How to Sync Two SQL Azure Databases?

101


What is the maximum size of sql server database?

513


Why olap is used?

573