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