Creating and using variables
In T-SQL, to create a variable you use the DECLARE statement. The variables must have an at sign (@) as their first character. Like most things in T-SQL, variables are not case sensitive. To assign a value to a variable, you can either use the keyword SET or a SELECT statement, then the variable name followed by an equal sign and a value.
Latihan ini merupakan bagian dari kursus
Intermediate SQL Server
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- Declare the variable (a SQL Command, the var name, the datatype)
___
-- Set the counter to 20
___
-- Select the counter
SELECT @counter