Third, output the content of the variables:<\/p>\n\n\n\n
123<\/td>
SELECT @product_name AS product_name, @list_price AS list_price;<\/td><\/tr><\/tbody><\/table>\n\n\n\n
<\/figure>\n\n\n\n
Accumulating values into a variable<\/h2>\n\n\n\n
The following stored procedure takes one parameter and returns a list of products as a string:<\/p>\n\n\n\n
1234567891011121314151617181920<\/td>
CREATE PROC uspGetProductList( @model_year SMALLINT) AS BEGIN DECLARE @product_list VARCHAR(MAX); SET @product_list = ”; SELECT @product_list = @product_list + product_name + CHAR(10) FROM production.products WHERE model_year = @model_year ORDER BY product_name; PRINT @product_list;END;<\/td><\/tr><\/tbody><\/table>\n\n\n\n
In this stored procedure:<\/p>\n\n\n\n
First, we declared a variable named @product_list<\/code> with varying character string type and set its value to blank.<\/li>
Second, we selected the product name list from the products table based on the input @model_year<\/code>. In the select list, we accumulated the product names to the @product_list<\/code> variable. Note that the CHAR(10)<\/code> returns the line feed character.<\/li>
Third, we used the PRINT<\/code> statement to print out the product list.<\/li><\/ul>\n\n\n\n
The following statement executes the uspGetProductList<\/code> stored procedure:<\/p>\n\n\n\n
The following picture shows the partial output:<\/p>\n\n\n\n<\/figure>\n\n\n\n
In this tutorial, you have learned about variables including declaring variables, setting their values, and assigning value fields of a record to the variables.<\/p>\n","protected":false},"excerpt":{"rendered":"
What is a variable A variable is an object that holds a single value of a specific type e.g., integer, date, or varying character string. We typically use variables in the following cases: As a loop counter to count… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,18,19],"tags":[],"_links":{"self":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/138"}],"collection":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/comments?post=138"}],"version-history":[{"count":1,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/138\/revisions"}],"predecessor-version":[{"id":139,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/138\/revisions\/139"}],"wp:attachment":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/categories?post=138"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/tags?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Stored](\"http:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/Stored-Procedure-Variables-execute-a-code-block.png\")
<\/figure>\n\n\n\n![\"Stored](\"http:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/Stored-Procedure-Variables-output.png\")
<\/figure>\n\n\n\n![\"Stored](\"http:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/Stored-Procedure-Variables-assign-a-record-to-a-variable.png\")
<\/figure>\n\n\n\n![\"Stored](\"http:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/Stored-Procedure-Variables-Stored-Procedure-Example.png\")
<\/figure>\n\n\n\n