From the course: Complete Guide to Advanced SQL Server

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Stored procedure input parameters

Stored procedure input parameters - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Stored procedure input parameters

“

Like functions, stored procedures can include input parameters to alter the actions that the stored procedure performs. Unlike functions and views, though, stored procedures can write data to our existing tables rather than just returning existing values. Let's take a look at both capabilities by exploring the data and adding rows to the Wide World Importers' Warehouse.Colors table. Let's first take a look at its current content by selecting everything from Warehouse.Colors, and I'm going to order by the ColorID descending. This table has five columns, but to add a new row, we only need to supply values for the first three. The ValidFrom and ValidTo columns are automatically populated by SQL Server since this is a system version or a temporal table that keeps a record for when rows are added and modified. So let's focus on the first three columns. The ColorID is the primary key for the table. Integer values here are all one larger than the previous row. Notice that the highest value…

Contents