What is the difference between Stored Procedure and Functions ?

1. Full .NET Interview Course
C# / ASP.NET Core / MVC / API - Top 500 Interview Questions
www.udemy.com/course/csharp-o...
Don't worry if course not helping you, Udemy has 30 days Free Refund Policy.
2. Quick Revision Book (PDF format)
Top 500 .NET Interview Questions - OOPS/ C#/ ASP.Net/ MVC/ SQL /.Net Core /Web API
imojo.in/interviewhappy
50% Discount Applied on above link.
Don't worry if book not helping you, I will return 100% of your money with in 7 days of purchase. Just mail me at [e-mail].
My best wishes are with you.

[@kavitakumawat9929]

I have started liking your content, its quite apt and to the point! Thank you :)

[@interviewhappy]

Happy to hear that! @kavita

[@lokeshleo8354]

Hi Sir I have a doubt, we can use SQL statements in SPs is it correct?

[@charlesopuoro5295]

Thanks a whole lot for this.

[@interviewhappy]

Your Welcome @ Charles

[@hasanmougharbel8030]

Hey there, Great efforts in this channel.
I have learned recently about assemblies.
In what way, Assemblies are different from stored procedures?
I appreciate your help at your sole convenience.
Thanks a lot.

[@interviewhappy]

Hi Hasan, Assemblies are in .NET framework and Stored Procedures are in sql server.
Assembly is the compile code and stored procedure is the compiled set of queries.

[@tesfayekebebe2553]

Thanks a lot bro.

[@interviewhappy]

Always welcome

[@CHANDRUS-ur3ls]

Points are very apt thank you

[@interviewhappy]

welcome @chandrus

[@2784raj]

Thanks you sirji...

[@interviewhappy]

wc Raj

[@nikitabathini2169]

Thank you Sir

[@interviewhappy]

Most welcome

[@sergeymigel4680]

thank you

[@interviewhappy]

Welcome Sergey. Wish you all the best.

[@abhishekkumarsingh3678]

Oh you are from spain
Great!!

[@interviewhappy]

Hehe.. Bhai, I am from India..

[@psrikant1342]

One more difference is we cannot use DML statements in functions..is that right ?

[@shriraamr1284]

yes little mistake