From the course: Complete Guide to Advanced SQL Server

Unlock this course with a free trial

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

Return values with indexes and series

Return values with indexes and series - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Return values with indexes and series

“

Sometimes your Python scripts won't start with values that are stored in a SQL Server data table. Maybe your script is collecting information from an external resource, like a text file, or scraping information that's published on a website. Or maybe your Python script is generating values all on its own, completely inside of the script itself. When you're not starting with data that's coming from SQL Server, it's going to be important to know how to organize it. Individual data values are called scalars. For instance, if I create a variable called A and assign it the value of Apple. This variable is a scalar. It holds a single value. I can create additional variables that are also scalars. For instance, B is equal to Banana and C is equal to Cherry. If I wanted to work with all of these scalar variables together, it becomes a little bit cumbersome. For instance, to print each one out, I need to type out all of their names. It's much more convenient if I collect all of these scalars…

Contents