局部变量:
以“@”开头的标识符表示变量(局部变量),该变量必须先用DECLARE命令声明后才能使用:
DECLARE @js_age int;
DECLARE @name varchar(32), @address varchar(64);
使用DECLARE命令并创建局部变量后,初始值为NULL,可以使用SELECT或SET命令这只局部变量的值,
示例1:声明、赋值、输出:
DECLARE @js_age INT
SELECT @js_age = 28
SELECT @js_age AS 年龄
GO
示例2:通过查询语句给变量赋值:
DECLARE @js_rows INT
SET @js_rows = (SELECT COUNT(*) FROM PERSON)
SELECT @js_rows as 行数
GO
示例3:使用由SET赋值的局部变量进行查询:
USE test
GO
DECLARE @js_address VARCHAR(64)
SET @js_address = 'AAAAA'
SELECT RTRIM(FirstName) + ' ' + RTRIM(LastName) AS Name, @js_address AS ADDRESS
FROM PERSON
GO