游标有关问题

htl258_Tony 2009-02-22 08:29:40 
DECLARE @t TABLE (ID int identity,Name varchar(50),Class varchar(50),[Values] int)

INSERT @t SELECT 'AA','A',2

UNION ALL SELECT 'BB','B',1

UNION ALL SELECT 'CC','D',1

UNION ALL SELECT 'AA','A',3

UNION ALL SELECT 'BC','C',5

UNION ALL SELECT 'BB','S',7

UNION ALL SELECT 'BD','V',8

UNION ALL SELECT 'BB','W',9

UNION ALL SELECT 'BE','R',6

UNION ALL SELECT 'BE','R',5

UNION ALL SELECT 'BE','W',9

UNION ALL SELECT 'BB','R',2

UNION ALL SELECT 'BF','W',1

UNION ALL SELECT 'BF','R',7

UNION ALL SELECT 'BG','Q',7



/*SELECT * FROM @t ORDER BY NAME

ID Name Class Values

1	AA	A	2

4	AA	A	3

2	BB	B	1

8	BB	W	9

12	BB	R	2

6	BB	S	7

5	BC	C	5

7	BD	V	8

9	BE	R	6

10	BE	R	5

11	BE	W	9

13	BF	W	1

14	BF	R	7

15	BG	Q	7

3	CC	D	1

*/

DECLARE

 @Name VARCHAR(20),@Class VARCHAR(50),@Values INT,

 @PName VARCHAR(20),@PClass VARCHAR(50),@PValues INT;



DECLARE @t1 TABLE(Name varchar(20),Class varchar(50),[Values] int);



DECLARE C CURSOR FOR 

  SELECT Name,Class,[Values] FROM @t ORDER BY NAME;



OPEN C;



FETCH NEXT FROM C INTO @Name,@Class,@Values;

SELECT @PName=@Name,@PClass ='',@PValues=0;



WHILE @@fetch_status = 0

BEGIN

  IF @Name <> @PName

  BEGIN

    INSERT INTO @t1 VALUES(@PName,STUFF(@PClass,1,1,''),@PValues);

    SELECT @PName=@Name,@PClass ='',@PValues=0;

  END



  SELECT @PClass=@PClass+'、'+@Class,@PValues=@PValues+@Values;



  FETCH NEXT FROM C INTO @Name,@Class,@Values;

END



CLOSE C



DEALLOCATE C



SELECT * FROM @t1;



/* 

Name                 Class                                              Values

-------------------- -------------------------------------------------- -----------

AA                   A、A                                                5

BB                   B、W、R、S                                            19

BC                   C                                                  5

BD                   V                                                  8

BE                   R、R、W                                              20

BF                   W、R                                                8

BG                   Q                                                  7



(7 行受影响)

*/

我正在学用游标，请问这里有一行显示不出来，请问要哪里调一下？
...全文
71 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
htl258_Tony 2009-02-23
  • 打赏
  • 举报
 回复
这是我最想要的。[Quote=引用 3 楼 happyflystone 的回复:]
SQL codeDECLARE @t TABLE (ID int identity,Name varchar(50),Class varchar(50),[Values] int)
INSERT @t SELECT 'AA','A',2
UNION ALL SELECT 'BB','B',1
UNION ALL SELECT 'CC','D',1
UNION ALL SELECT 'AA','A',3
UNION ALL SELECT 'BC','C',5
UNION ALL SELECT 'BB','S',7
UNION ALL SELECT 'BD','V',8
UNION ALL SELECT 'BB','W',9
UNION ALL SELECT 'BE','R',6
UNION ALL SELECT 'BE','R',5
UNION ALL SELECT…
[/Quote]
-狙击手- 2009-02-22
  • 打赏
  • 举报
 回复 
DECLARE @t TABLE (ID int identity,Name varchar(50),Class varchar(50),[Values] int)

INSERT @t SELECT 'AA','A',2

UNION ALL SELECT 'BB','B',1

UNION ALL SELECT 'CC','D',1

UNION ALL SELECT 'AA','A',3

UNION ALL SELECT 'BC','C',5

UNION ALL SELECT 'BB','S',7

UNION ALL SELECT 'BD','V',8

UNION ALL SELECT 'BB','W',9

UNION ALL SELECT 'BE','R',6

UNION ALL SELECT 'BE','R',5

UNION ALL SELECT 'BE','W',9

UNION ALL SELECT 'BB','R',2

UNION ALL SELECT 'BF','W',1

UNION ALL SELECT 'BF','R',7

UNION ALL SELECT 'BG','Q',7

--UNION ALL SELECT 'cc','Q',7

/*SELECT * FROM @t ORDER BY NAME

ID Name Class Values

1    AA    A    2

4    AA    A    3

2    BB    B    1

8    BB    W    9

12    BB    R    2

6    BB    S    7

5    BC    C    5

7    BD    V    8

9    BE    R    6

10    BE    R    5

11    BE    W    9

13    BF    W    1

14    BF    R    7

15    BG    Q    7

3    CC    D    1

*/

DECLARE

 @Name VARCHAR(20),@Class VARCHAR(50),@Values INT,

 @PName VARCHAR(20),@PClass VARCHAR(50),@PValues INT;



DECLARE @t1 TABLE(Name varchar(20),Class varchar(50),[Values] int);



DECLARE C CURSOR FOR 

  SELECT Name,Class,[Values] FROM @t ORDER BY NAME;



OPEN C;



FETCH NEXT FROM C INTO @Name,@Class,@Values;

SELECT @PName=@Name,@PClass ='',@PValues=0;



WHILE @@fetch_status = 0

BEGIN

  IF @Name <> @PName

  BEGIN

    INSERT INTO @t1 VALUES(@PName,STUFF(@PClass,1,1,''),@PValues);

    SELECT @PName=@Name,@PClass ='',@PValues=0;

  END



  SELECT @PClass=@PClass+'、'+@Class,@PValues=@PValues+@Values;



  FETCH NEXT FROM C INTO @Name,@Class,@Values;

END

----------------------------------------------------------------------

INSERT INTO @t1 VALUES(@PName,STUFF(@PClass,1,1,''),@PValues);

---------------------------------------------------------------------



CLOSE C



DEALLOCATE C



SELECT * FROM @t1;
-狙击手- 2009-02-22
  • 打赏
  • 举报
 回复 
DECLARE @t TABLE (ID int identity,Name varchar(50),Class varchar(50),[Values] int)

INSERT @t SELECT 'AA','A',2

UNION ALL SELECT 'BB','B',1

UNION ALL SELECT 'CC','D',1

UNION ALL SELECT 'AA','A',3

UNION ALL SELECT 'BC','C',5

UNION ALL SELECT 'BB','S',7

UNION ALL SELECT 'BD','V',8

UNION ALL SELECT 'BB','W',9

UNION ALL SELECT 'BE','R',6

UNION ALL SELECT 'BE','R',5

UNION ALL SELECT 'BE','W',9

UNION ALL SELECT 'BB','R',2

UNION ALL SELECT 'BF','W',1

UNION ALL SELECT 'BF','R',7

UNION ALL SELECT 'BG','Q',7

--UNION ALL SELECT 'cc','Q',7

/*SELECT * FROM @t ORDER BY NAME

ID Name Class Values

1    AA    A    2

4    AA    A    3

2    BB    B    1

8    BB    W    9

12    BB    R    2

6    BB    S    7

5    BC    C    5

7    BD    V    8

9    BE    R    6

10    BE    R    5

11    BE    W    9

13    BF    W    1

14    BF    R    7

15    BG    Q    7

3    CC    D    1

*/

DECLARE

 @Name VARCHAR(20),@Class VARCHAR(50),@Values INT,

 @PName VARCHAR(20),@PClass VARCHAR(50),@PValues INT;



DECLARE @t1 TABLE(Name varchar(20),Class varchar(50),[Values] int);



DECLARE C CURSOR FOR 

  SELECT Name,Class,[Values] FROM @t ORDER BY NAME;



OPEN C;



FETCH NEXT FROM C INTO @Name,@Class,@Values;

SELECT @PName=''



WHILE @@fetch_status = 0

BEGIN



  IF @Name <> @PName

  BEGIN

    INSERT INTO @t1 VALUES(@Name,@Class,@Values);

    SELECT @PName=@Name;

  END

  else

      update @t1

      set class = class+'、'+@Class,[Values]=[Values]+@Values

      where [name] = @name;



  --SELECT @PClass=@PClass+'、'+@Class,@PValues=@PValues+@Values;



  FETCH NEXT FROM C INTO @Name,@Class,@Values;

END



CLOSE C



DEALLOCATE C



SELECT * FROM @t1;

Name                 Class                                              Values

-------------------- -------------------------------------------------- -----------

AA                   A、A                                                5

BB                   B、W、R、S                                            19

BC                   C                                                  5

BD                   V                                                  8

BE                   R、R、W                                              20

BF                   W、R                                                8

BG                   Q                                                  7

CC                   D                                                  1
htl258_Tony 2009-02-22
  • 打赏
  • 举报
 回复
3 CC D 1
-------------------
这一行没有插到表里
约瑟夫问题的游标实现
约瑟夫问题的游标实现，可以自己设置杀人的个数
LabVIEW 的游标图例
游标图例用来显示图形中的游标，如图1所示。在图形上用游标可读取绘图区域上某个点的确切值，游标值会显示在游标图例中。 　图1 图形缩放方式  图2 游标图例 　选择游标图例右键快捷菜单的“创建游标”，在...
SQL Server 2014 索引和游标
主讲内容： 第一讲 课程简介 第二讲 索引简介 第三讲 创建索引 第四讲 查看索引 第五讲 索引管理 第六讲 全文索引 等课程
oracle游标的总结oracle游标的总结
oracle游标的总结oracle游标的总结oracle游标的总结oracle游标的总结oracle游标的总结oracle游标的总结oracle游标的总结oracle游标的总结oracle游标的总结
波形图游标功能_获取游标_
设置波形图的游标，设置游标参数，设置多个游标，可自由拖动。
MS-SQL Server

34,597

社区成员

254,586

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章