风之语者

摘要： DECLARE cursor1 CURSOR FORSELECT * FROM @tb1--打开游标OPEN cursor1--获取数据，游标下移一行FETCH NEXT FROM cursor1 INTO @id, @xm--检测获取数据是否成功WHILE @@fetch_status=0BEGIN --显示通过游标赋值的变量PRINT STR(@id) + '-' + @xm--游标继续下移 FETCH NEXT FROM cursor1 INTO @id, @xmEND--关闭游标CLOSE cursor1--释放游标Deallocate cursor1 阅读全文