T-SQL
缂栫▼锛堝弬鐓ф暀鏉愬鐢熸垚缁╃鐞嗘暟鎹簱锛?/p>
1
銆佺紪鍐?/p>
T-SQL
鏌ユ壘鐜嬫晱鐨勫墠涓�涓鍙峰鐢熷拰鍚庝竴涓鍙峰鐢熺殑
鐩稿叧淇℃伅
銆?/p>
Declare
@name
varchar
(
10
)
Set
@name
=
'
鐜嬫晱
'
Select
*
from
student
where
Sname
=
@name
Declare
@SSno
int
Select
@SSno
=
Sno
from
student
Where
Sname
=
@name
Select
*
from
student
where
Sno
=
@SSno
+
1
Select
*
from
student
where
Sno
=
@SSno
-
1
2
銆佺粺璁″苟鏄剧ず
cno
涓衡�?/p>
2
鈥欑殑璇剧▼鐨勫钩鍧囧垎锛屽鏋滃钩鍧囧垎鍦?/p>
85
浠ヤ笂锛屾樉绀衡�滄垚缁╀紭绉�鈥滐紝骞舵樉绀烘渶楂樺鐢熺殑鎴愮哗锛涘鏋滃湪
85
浠ヤ笅锛屾樉绀衡�滄垚缁╄緝宸�滐紝骞舵樉绀烘渶浣庡鐢熺殑鎴愮哗銆?/p>
Set
NOCOUNT
ON
Declare
@Gradeavg
float
Select
@Gradeavg
=
AVG
(
Grade
)
from
SC