From the course: Complete Guide to Advanced SQL Server

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Parameterize the procedure

Parameterize the procedure - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Parameterize the procedure

“

There's an important additional benefit to turning your Python scripts into stored procedures, and it can be summed up in one word "customization." When your Python code incorporates parameters, you can easily modify the output of your script when it's saved as a stored procedure. Let's take another look at the same script that we used in the last movie. It currently generates 10 random numbers every time it's executed. But what if we'd like more control over how many numbers are returned in the result set? We can do that by passing in a variable to the script when we run the stored procedure. To do this, let's turn the number 10 in the for loop to a new variable. I'll use the lowercase letter n for this. Next, we'll go up here to the top and we'll add in a couple of empty lines. We'll start with the CREATE PROCEDURE line at the top. We already have a stored procedure in the Wide World Importers database called RandomNumbers, so I'm going to call this one BetterRandomNumbers. On the…

Contents