Procedimientos Almacenados y Funciones en SQL Server | Tutorial Completo con BikeStores | UNED

In this third tutorial of the UNED Database I (00826) course, we will study two of the main programmable objects in SQL Server: stored procedures and user-defined functions (UDFs). During the session, we will develop practical examples using the BikeStores database on Microsoft SQL Server Express, covering everything from basic syntax to creating procedures with parameters and reusable functions. Tutorial Content ✅ SQL Server Built-in Functions Aggregation Functions Text Functions Date Functions ✅ Stored Procedures What are they? Syntax Parameters Multiple Parameters ALTER PROCEDURE DROP PROCEDURE ✅ User-Defined Functions (UDFs) Syntax Scalar Functions Practical Examples Use within SELECT queries ✅ Differences between stored procedures and functions Finally, the requirements for Project 3 are reviewed, explaining the objectives of the activity and the correct way to approach its development.