早教吧作业答案频道 -->英语-->
SQL填空题求解DECLARE@COUNOVARCHAR(3),@COUNAMEVARCHAR(20)————————————FORSELECTCOUNO,COUNAMEFROMCOURSEORDERBYCOUNO————————————FETCH————FROMCRSCOURSEINTO@COUNO,@COUNAMEWHILE@@
题目详情
SQL填空题求解
DECLARE @COUNO VARCHAR(3),@COUNAME VARCHAR(20)
————————————
FOR SELECT COUNO,COUNAME FROM COURSE ORDER BY COUNO
————————————
FETCH ———— FROM CRSCOURSE INTO @COUNO,@COUNAME
WHILE @@FETCH_STATUS=0
BEGIN
PRINT '课程号:'+ @COUNO +'课程名称:' + @CouName
FETCH ———— FROM CRSCOURSE INTO @COUNO,@COUNAME
END
————————
DEALLOCATE CRSCOURSSE
在横线上填写.
题目是声明一个CRSCOURSE的游标,并利用游标遍历,显示整个结果,且从结果集最后一条记录显示到第一条记录
然后有一答案
1.Declare crscourse cursor
2.open crscourse
3.NEXT
4.NEXT
5.close crscourse
这个答案不知道有没有达到【从结果集最后一条记录显示到第一条记录】这个条件
DECLARE @COUNO VARCHAR(3),@COUNAME VARCHAR(20)
————————————
FOR SELECT COUNO,COUNAME FROM COURSE ORDER BY COUNO
————————————
FETCH ———— FROM CRSCOURSE INTO @COUNO,@COUNAME
WHILE @@FETCH_STATUS=0
BEGIN
PRINT '课程号:'+ @COUNO +'课程名称:' + @CouName
FETCH ———— FROM CRSCOURSE INTO @COUNO,@COUNAME
END
————————
DEALLOCATE CRSCOURSSE
在横线上填写.
题目是声明一个CRSCOURSE的游标,并利用游标遍历,显示整个结果,且从结果集最后一条记录显示到第一条记录
然后有一答案
1.Declare crscourse cursor
2.open crscourse
3.NEXT
4.NEXT
5.close crscourse
这个答案不知道有没有达到【从结果集最后一条记录显示到第一条记录】这个条件
▼优质解答
答案和解析
完全到达游标标准写法!
USE AdventureWorks
GO
-- Declare the variables to store the values returned by FETCH.
DECLARE @LastName varchar(50), @FirstName varchar(50)
DECLARE contact_cursor CURSOR FOR
SELECT LastName, FirstName FROM Person.Contact
WHERE LastName LIKE 'B%'
ORDER BY LastName, FirstName
OPEN contact_cursor
-- Perform the first fetch and store the values in variables.
-- Note: The variables are in the same order as the columns
-- in the SELECT statement.
FETCH NEXT FROM contact_cursor
INTO @LastName, @FirstName
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
-- Concatenate and display the current values in the variables.
PRINT 'Contact Name: ' + @FirstName + ' ' + @LastName
-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM contact_cursor
INTO @LastName, @FirstName
END
CLOSE contact_cursor
DEALLOCATE contact_cursor
GO
USE AdventureWorks
GO
-- Declare the variables to store the values returned by FETCH.
DECLARE @LastName varchar(50), @FirstName varchar(50)
DECLARE contact_cursor CURSOR FOR
SELECT LastName, FirstName FROM Person.Contact
WHERE LastName LIKE 'B%'
ORDER BY LastName, FirstName
OPEN contact_cursor
-- Perform the first fetch and store the values in variables.
-- Note: The variables are in the same order as the columns
-- in the SELECT statement.
FETCH NEXT FROM contact_cursor
INTO @LastName, @FirstName
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
-- Concatenate and display the current values in the variables.
PRINT 'Contact Name: ' + @FirstName + ' ' + @LastName
-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM contact_cursor
INTO @LastName, @FirstName
END
CLOSE contact_cursor
DEALLOCATE contact_cursor
GO
看了 SQL填空题求解DECLAR...的网友还看了以下:
英语完型填空解析. 从第80个一直到86个! 希望可以详细解释,而且可以详细解释我选错的那个答案英 2020-05-14 …
这些词组该填什么?下面这些怎么填呀?解放()解散()解除() 2020-05-17 …
用单词的正确形式填空,该怎么填?求解释1、Hesomeofhisoldphotosinanoldb 2020-06-11 …
用“弱”组词,并填空.解应用题是我们数学学习中的一个()环...用“弱”组词,并填空.解应用题是我 2020-06-25 …
已知△ABC中,a=181,b=209,A=121°,则此三角形解的情况是.(填“无解”或“一解” 2020-07-18 …
已知△ABC中,a=181,b=209,A=121°,则此三角形解的情况是.(填“无解”或“一解” 2020-07-18 …
(2009•海南)如图是密闭体系中某反应的徽观示意图,“”和“”分别表示不同原子.(1)反应后方框 2020-07-20 …
在算式“4×□+9×△=◇”的□、△中,分别填入一个正整数,使它们的倒数之和的最小值为5/6,则◇ 2020-07-30 …
先阅读,在填空解题(x+5)(x+6)=x的平方+11x+30(x+5)(x-先阅读,在填空解题( 2020-08-01 …
2*()/26>12/27最小可以填几,最大可以填几解题思路2*()/26>12/27最小可以填几, 2020-11-03 …