Create stored procedures and user-defined functions
|
Learn how to use Stored procedures to group T-SQL statements so they can be used and reused whenever needed. You may need to execute stored procedures that someone else has created or create your own.
Return results by executing stored procedures., Pass parameters to procedures., Create simple stored procedures that encapsulate a SELECT statement., Construct and execute dynamic SQL with EXEC and sp_executesql., Create simple user-defined functions and write queries against them.
Prerequisites
Before starting this module, you should have experience of using Transact-SQL queries to retrieve and filter data from a table in a database.
User Reviews
Be the first to review “Create stored procedures and user-defined functions”
Related Products
Business Analytics
Explore data analysis techniques to drive business performance and decision-making.
Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
Data Analysis with R
Learn how to analyze data using R programming, including statistical modeling and visualization techniques.
Learn Python for Data Science
Get started with Python for Data Science in this beginner-friendly skill path.
Firebase Analytics: Android
Discover how to implement and leverage Firebase Analytics for tracking user engagement and performance in Android apps.
Statistics for Data Analysis
Learn statistical methods and techniques for analyzing and interpreting data.
There are no reviews yet.