SqlServer游标
摘要:
declare @id intdeclare my_cursor cursorfor select id from mytableopen my_cursorfetch next from my_cursor into @idwhile(@@fetch_status=0)beginprint @idfetch next from my_cursor into @idendclose my_cursordeallocate my_cursor定义游标, 打开游标, 关闭游标, 清除游标 阅读全文
posted @ 2012-12-20 12:08 悉野 阅读(156) 评论(0) 推荐(0) 编辑