Difference between Store Procedure & Function - Advance Functionality смотреть онлайн

What is the difference between Function & Store Procedure?
Most of the people answers function return value and store procedure not.
Is it complete answer?
----------------------------------------------------
Wrong Answer!
----------------------------------------------------

What is right then?
----------------------------------------------------
Function & Store Procedure both can returns the values
Then what is the difference?

Difference
----------------------------------------------------

Function
----------------------------------------------------
Accept the input parameters
Compulsorily returns the values
We can’t call the store procedure
We can’t right the insert, update, delete statements
We can call the functions
We can call the extended store procedures
xp_cmdshell is one of the extended store procedure
Eg. EXEC master.dbo.xp_cmdshell 'dir'
This code returns the list of files from DOS


Store Procedure
----------------------------------------------------
Accept the input parameters
On-demand returns the values
Output parameters
Select statement
Print value
We can call the store procedure
We can right the insert, update, delete statements
We can call the functions
We can call the extended store procedures

----------------------------------------------------------------------------------------------------------------------------------------------------

A dynamic professional with qualitative IT experience in Windows and Web based application programming, testing, analyzing, requirement gathering, presentation, implementation and technical and non-technical documentation
Significant experience in Development, Implementation, Testing & Migration of Database including Schema from FoxPro to Oracle, FoxPro to MS SQL, MS SQL to Oracle

Certification
1997: Diploma in Computer Application (non-Polytechnic)
1997: Diploma in Hardware Technology (non-Polytechnic)
1997: Diploma in Desktop Publication (non-Polytechnic)
2018: Develop Opencv Based Facial Recognition System Using C#
https://www.udemy.com/certificate/UC-SYAP2TWL/
2018: Build An App With ASPNET Core And Angular From Scratch
https://www.udemy.com/certificate/UC-XLWHQKXV/
2019: Angular (Full App) with Angular Material, Angularfire & NgRx
https://www.udemy.com/certificate/UC-YBE66QGP/


Technologies
---------------------------------------------------------------------------------------------------------------------
.Net Core
Entity Framework
Angular CLI 8
TypeScript
ASP.Net
MVC
C#.Net
XML
HTML
VB.Net
VB 6.0
Microsoft SQL Server
Oracle PL/SQL
Magic XPA Development & Implementation
FoxPro 2.6
Specialties: Database Migration, Accounts, Transport, Textile & Inventory Domains

Ideas on YouTube
https://www.youtube.com/channel/UCS7URu2BCECX8rxh_lpPNVw