declare @kk varchar(1000) Set @kk='' select @kk = @kk + game_id from ft_game print @kk
declare @cnt numeric(18,0) declare @i numeric(18,0) declare @kk varchar(8000) declare @kkk varchar(2000) set @kk = '' select @cnt = count(*) from ft_gameDECLARE game_id_cursor CURSOR FOR SELECT game_id FROM ft_gameOPEN game_id_cursorFETCH NEXT FROM game_id_cursor INTO @kkk WHILE @@FETCH_STATUS = 0 BEGIN set @kk = @kk + @kkk end close game_id_cursor print @kk
老兄 下面这种写法好像 是个死循环declare @cnt numeric(18,0) declare @i numeric(18,0) declare @kk varchar(8000) declare @kkk varchar(2000) set @kk = '' select @cnt = count(*) from ft_gameDECLARE game_id_cursor CURSOR FOR SELECT game_id FROM ft_gameOPEN game_id_cursorFETCH NEXT FROM game_id_cursor INTO @kkk WHILE @@FETCH_STATUS = 0 BEGIN set @kk = @kk + @kkk end close game_id_cursor print @kk
Set @kk=''
select @kk = @kk + game_id from ft_game
print @kk
declare @i numeric(18,0)
declare @kk varchar(8000)
declare @kkk varchar(2000)
set @kk = ''
select @cnt = count(*) from ft_gameDECLARE game_id_cursor CURSOR FOR
SELECT game_id
FROM ft_gameOPEN game_id_cursorFETCH NEXT FROM game_id_cursor
INTO @kkk
WHILE @@FETCH_STATUS = 0
BEGIN
set @kk = @kk + @kkk
end
close game_id_cursor
print @kk
declare @i numeric(18,0)
declare @kk varchar(8000)
declare @kkk varchar(2000)
set @kk = ''
select @cnt = count(*) from ft_gameDECLARE game_id_cursor CURSOR FOR
SELECT game_id
FROM ft_gameOPEN game_id_cursorFETCH NEXT FROM game_id_cursor
INTO @kkk
WHILE @@FETCH_STATUS = 0
BEGIN
set @kk = @kk + @kkk
end
close game_id_cursor
print @kk