用游标呀DEALLOCATE myCursordeclare myCursor cursor for select id from useropen myCursordeclare @IdList varchar(500) declare @C varchar(700) set @C = '' fetch next from myCursor Into @IdListwhile @@FETCH_STATUS = 0begin set @C = @C + @IdList + ',' FETCH NEXT FROM myCursor INTO @IdListend select @C
游标 DECLARE @RtnStr VARCHAR(8000) DECLARE @TempStr VARCHAR(10) set @RtnStr = '' set @TempStr = ''DECLARE My_Cursor CURSOR FOR SELECT ID FROM [USER]OPEN My_Cursor FETCH NEXT FROM My_Cursor INTO @TempStr IF @@FETCH_STATUS = 0 BEGIN SET @RtnStr = @RtnStr +@TempStr + ',' SET @TempStr = '' FETCH NEXT FROM My_Cursor INTO @TempStr END
declare @C varchar(700)
set @C = ''
fetch next from myCursor Into @IdListwhile @@FETCH_STATUS = 0begin set @C = @C + @IdList + ',' FETCH NEXT FROM myCursor
INTO @IdListend select @C
DECLARE @RtnStr VARCHAR(8000)
DECLARE @TempStr VARCHAR(10)
set @RtnStr = ''
set @TempStr = ''DECLARE My_Cursor CURSOR
FOR SELECT ID FROM [USER]OPEN My_Cursor
FETCH NEXT FROM My_Cursor INTO @TempStr
IF @@FETCH_STATUS = 0
BEGIN
SET @RtnStr = @RtnStr +@TempStr + ','
SET @TempStr = ''
FETCH NEXT FROM My_Cursor INTO @TempStr
END