注:Stulinfo为个人所建表
set
与
SELECT
简而言之就是
set
使用了直接给定一个变量一个固定的“值”,而
SELECT
是一个人意愿为前提的添加的一个在随机的变量。来源于表中以一个条件为允,的进行选择的这么一个变量。
DECLARE
@
name
varchar
(8)
SET
@
name
=
'罗晓璐'
SELECT
*
FROM
Stulinfo
WHERE
sName = @
name
/*
DECLARE
@seat
int
SELECT
@seat=sSeat
FROM
Stulinfo
WHERE
sName=@
name
SELECT
*
FROM
Stulinfo
WHERE
(sSeat = @seat+1)
OR
(sSeat = @seat-1)
GO
DECLARE
@
name
varchar
(8)
SELECT
@
name
=sName
FROM
Stulinfo
WHERE
sNo=
'95002'
SELECT
*
FROM
Stulinfo
WHERE
sName = @
name
/*
DECLARE
@seat
int
SELECT
@seat=sSeat
FROM
Stulinfo
WHERE
sName=@
name
SELECT
*
FROM
Stulinfo
WHERE
(sSeat = @seat+1)
OR
(sSeat = @seat-1)
GO
结果: