create PROCEDURE bookcursor
@bookID varCHAR(10)
AS
declare
@bookIDID VARCHAR(10),
@bookName VARCHAR(10),
@bookprice money
select * from book WHERE bookID=@bookID
begin
declare cur_01 cursor scroll dynamic for select bookID from book WHERE bookID=@bookID
open cur_01
fetch next from cur_01 into @bookIDID
while(@@fetch_status=0)
begin
declare cur_02 cursor scroll dynamic for select bookName from book WHERE bookID=@bookID
open cur_02
fetch next from cur_02 into @bookName
while(@@fetch_status=0)
begin
declare cur_03 cursor scroll dynamic for select bookprice from book WHERE bookID=@bookID
open cur_03
fetch next from cur_03 into @bookprice
while(@@fetch_status=0)
begin
insert into book (bookID,bookName,bookprice)VALUES(@bookID,@bookName,@bookprice)
fetch next from cur_03 into @bookprice
end
close cur_03
deallocate cur_03
fetch next from cur_02 into @bookName
end
close cur_02
deallocate cur_02
fetch next from cur_01 into @bookIDID
end
close cur_01
deallocate cur_01
endselect * from book WHERE bookID=@bookID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
@bookID varCHAR(10)
AS
declare
@bookIDID VARCHAR(10),
@bookName VARCHAR(10),
@bookprice money
select * from book WHERE bookID=@bookID
begin
declare cur_01 cursor scroll dynamic for select bookID from book WHERE bookID=@bookID
open cur_01
fetch next from cur_01 into @bookIDID
while(@@fetch_status=0)
begin
declare cur_02 cursor scroll dynamic for select bookName from book WHERE bookID=@bookID
open cur_02
fetch next from cur_02 into @bookName
while(@@fetch_status=0)
begin
declare cur_03 cursor scroll dynamic for select bookprice from book WHERE bookID=@bookID
open cur_03
fetch next from cur_03 into @bookprice
while(@@fetch_status=0)
begin
insert into book (bookID,bookName,bookprice)VALUES(@bookID,@bookName,@bookprice)
fetch next from cur_03 into @bookprice
end
close cur_03
deallocate cur_03
fetch next from cur_02 into @bookName
end
close cur_02
deallocate cur_02
fetch next from cur_01 into @bookIDID
end
close cur_01
deallocate cur_01
endselect * from book WHERE bookID=@bookID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
解决方案 »
- winform项目中获取CPU和硬盘编号
- 网站传上虚拟主机后,数据能读取,为什么不能添加数据
- 继承GridView自定义控件开发增加属性问题
- 请教 如何设置背景图片只在没编辑区域显示,编辑区域依然显示本有的颜色
- ■■■谁用过FileIOPermission.Assert方法?■■■
- 请问怎样在Page_Load中分辨来源
- ASP.NET web开发要用到NET Frameowrk4.5吗?
- 求点击打印按钮导出自动行列表格并可以打印的源代码
- 好痛苦啊!弄的现在什么都不能做!请教高手,谢谢先!
- 使用Request.Form获取返回值出现的问题?
- 改变Dropdownlist的选项,怎样使属性TextMode=password的TextBox1输入的内容不丢失?
- 早晨好~!我有个问题,关于asp.net+c#上传大文件的问题,望大家帮帮我~!十分感激~!
3 《我的仲夏之旅》 38.0000
4 《我仇视漂亮的女人》 30.0000
5 《我的女朋友是个很丰满的瘦子》 38.0000
1 《我的小小城堡》 126.0000
直接用fetch next from cur into @id,@name,@price不就可以了?
或者我看错了?
关键是问什么它停不下来
UP
UP
UP
UP
`
`
`
`
`
`