How to declare a variable in SQL?

Question

Can anyone explain how to declare a variable in SQL?

Answer 1

In SQL, we can declare a variable using DECLARE statement. The following statement is used to declare a variable named @start_year:

DECLARE @start_year SMALLINT;

In above statement, SMALL INT is a datatype of @start_year variable.

If we want to assign the value, we can use the SET statement. Use the following statement to assign ‘2020’ value to the variable @start_year we have created:

SET @start_year = 2020;

If you wish to learn SQL from Industry experts, I recommend enrolling in this SQL Course by Intellipaat that provides instructor-led training, and also certification.