sql server 游标问题。

SQL code:
DECLARE @creater VARCHAR(100)
Declare MyCusror2 Cursor Scroll
For
SELECT OMC_Creater
from dbo.YB_Opr_MessageBoardCourse INNER JOIN
dbo.YB_Tec_Course ON dbo.YB_Opr_MessageBoardCourse.RC_ID = dbo.YB_Tec_Course.RC_ID INNER JOIN
dbo.YB_Sys_Channel ON dbo.YB_Tec_Course.SC_ID = dbo.YB_Sys_Channel.SC_ID INNER JOIN
dbo.YB_Sys_Subject ON dbo.YB_Tec_Course.Subject_ID = dbo.YB_Sys_Subject.Subject_ID

Open MyCursor2
Fetch next from MyCursor
Into @creater
While(@@Fetch_Status = 0)
Begin
Begin
PRINT @creater
End
Fetch next from MyCursor
Into @creater
End
Close MyCusror2
Deallocate MyCusror2


执行出现这样的问题：
Msg 16916, Level 16, State 1, Line 4
A cursor with the name 'MyCursor2' does not exist.
Msg 16916, Level 16, State 1, Line 11
A cursor with the name 'MyCursor' does not exist.
Msg 16917, Level 16, State 1, Line 21
Cursor is not open.


求解！！！！

---

MyCursor2
MyCursor1都不存在
或者没有打开?

---

Fetch next from MyCursor2

---

不会游标
友情帮顶

---

Fetch next from MyCursor2

---

改成  Fetch next from MyCurs