变量.sql

来自「SQL Server数据库设计和高级查询[SQL Advance]」· SQL 代码 · 共 12 行

/*--查找李文才的信息--*/
DECLARE @name varchar(8)
SET @name='李文才'      --使用SET赋值
SELECT * FROM stuInfo where stuName = @name

/*--查找李文才的左右同桌--*/
DECLARE @seat int
SELECT @seat=stuSeat from stuInfo where stuName=@name  --使用SELECT赋值
SELECT * FROM stuInfo where (stuSeat = @seat+1) or (stuSeat = @seat-1)
GO