MS SQL - Define and set your own variables

In MS SQL server, you can define and set your own variables. This is useful when you want to reuse the result values to the next query.

Here is an example how to do it.

DECLARE @my_product_id INT, @my_product_name VARCHAR(255)
SET @my_product_id = 1234
SET @my_product_name = 'fruit'
 
SELECT @my_product_id, @my_product_name

Output