SQL Stored Procedures, Parameters & Use Cases | SQL for Data Analysis Episode 11 |

In this short tutorial we'll be focusing on SQL Stored Procedures. More specifically the basic syntax, how we can create, modify and delete Stored Procedures and use parameters to improve the dynamic nature of SQL & automate processes.
From there we'll look at the System Catalogues to view Stored Procedures and bring everything together!
🤝 Connect with me on LinkedIn:
/ ja376
Please Like, Subscribe, Comment & Share if you enjoy!

[@chaithanyavamshi2898]

WOW!!Such an insightful and crisp video about Stored Procedures. Can't wait to explore and learn more from you Andrew👏

[@jonathanfinerfrock304]

Great beginner example and I appreciate your teaching style. nicely done!

[@MatadorSoftware]

Appreciate you stopping by and leaving a comment, Jonathan! Thanks!

[@adammain6159]

so many possibilities. thanks for this one

[@MatadorSoftware]

There is indeed, I’m glad you enjoyed!

[@SirFarkade]

That was a great explation

[@MatadorSoftware]

Really appreciate that!

[@hanhnguyenhong3039]

Xin cảm ơn!

[@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.

[@MatadorSoftware]

Thanks Hasan!
Assemblies are DLL files used in an instance of SQL Server to deploy functions, stored procedures, triggers, user-defined aggregates, and user-defined types that are written in one of the managed code languages hosted by the Microsoft .NET Framework common language runtime (CLR), instead of in Transact-SQL.
Where as SQL Server stored procedures are used to group one or more Transact-SQL statements into logical units. The stored procedure is stored as a named object in the SQL Server Database Server.

[@hasanmougharbel8030]

@@MatadorSoftware I have learned a lot from your explanation...thanks a lot