初学游标，大家帮我看看为啥不对呀

2010-03-04 11:13:32 87 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

存储过程——游标循环 sqlserver中的循环遍历（游标循环）https://www.cnblogs.com/xielong/p/5941595.html，博主小小邪。---------------------------------------------上面是博主学习的博客↑---------------------------------------------下面是个人实践经验，感觉比较适合小白同学注意的地方... 阅读详情

这是我建的表和数据
CREATE TABLE Candidate1 (cName CHAR(6) PRIMARY KEY,
cPhone CHAR(11),siScore SMALLINT
)
-------------------------------
INSERT INTO Candidate1 VALUES ('刘晓亮','13703236886',90)
INSERT INTO Candidate1 VALUES('孙红娟','13803992299',70)
INSERT INTO Candidate1 VALUES('李明传','13902199889',80)
------------------------------
这是我写的游标
DECLARE @Count int
DECLARE @Name CHAR(6),@Phone CHAR(11),@Score SMALLINT
DECLARE my_cur CURSOR FOR SELECT * FROM Candidate1
OPEN my_cur
select @Count=COUNT(*) FROM Candidate1
WHILE (@@FETCH_STATUS=0 AND @Count>0)
BEGIN
FETCH NEXT FROM my_cur INTO @Name,@Phone,@Score
CASE
WHEN @Score>90 THEN PRINT @Name+@Phone+'优秀'
WHEN @Score>=80 AND @Score<90 THEN PRINT @Name+@Phone+'良好'
WHEN @Score>=60 AND @Score<80 THEN PRINT @Name+@Phone+'及格'
ELSE PRINT @Name+@Phone+'不及格'
SET @Count=@Count-1
END
CLOSE my_cur
DEALLOCATE my_cur
---------------------------
我要是用if...else 结构就正确了，我想用case..when...then..结构实现

...全文