sql游标学习

--声明局部变量
DECLARE @ID VARCHAR(50), @STUID VARCHAR(50),@TYPE VARCHAR(50)
DECLARE @NAME VARCHAR(50),@SEX VARCHAR(50),@AGE INT

DECLARE MONITORDATA CURSOR FOR	--声明游标
SELECT NEWID() STUDENTID, 'A',STUDENTNAME,STUDENTSEX,STUDENTAGE FROM [StudentData].dbo.[STUDENT]

OPEN MONITORDATA --打开游标
FETCH NEXT FROM MONITORDATA INTO @ID,@STUID,@TYPE,@NAME,@SEX,@AGE

--游标读取下一条数据是否成功(0: FETCH 语句成功;-1 FETCH 语句失败或此行不在结果集中;-2 被提取的行不存在)
WHILE @@FETCH_STATUS = 0   
BEGIN 
	INSERT INTO STUDENT_INFO(ID,STUID,TYPE) 
	SELECT @ID,@STUID,@TYPE
	
	INSERT INTO STUDENT_INFO1(ID,INFOID,NAME,SEX,AGE)
	SELECT NEWID(),@ID,@NAME,@SEX,@AGE
	FETCH NEXT FROM MONITORDATA INTO @ID,@STUID,@TYPE,@NAME,@SEX,@AGE
END
CLOSE  MONITORDATA	--关闭游标
DEALLOCATE MONITORDATA	--释放游标
RETURN