看看下面这样可行?declare @lvStr char(200), @sID char(10), @sNAME char(20)
select @lvStr=''
select @sID=min(coOwerShipID) from coOwnerShip
while @@rowcount>0
begin
select @sNAME=coOwnerName from coOwnerShip where coOwerShipID=@sID
select @lvStr=rtrim(@lvStr)+' '+rtrim(@sID)+' '+rtrim(@sNAME)
select @sID=min(coOwerShipID) from coOwnerShip where coOwerShipID>@sID
endselect @lvStr
select @lvStr=''
select @sID=min(coOwerShipID) from coOwnerShip
while @@rowcount>0
begin
select @sNAME=coOwnerName from coOwnerShip where coOwerShipID=@sID
select @lvStr=rtrim(@lvStr)+' '+rtrim(@sID)+' '+rtrim(@sNAME)
select @sID=min(coOwerShipID) from coOwnerShip where coOwerShipID>@sID
endselect @lvStr
declare @lvStr varchar(2000), @sID char(10), @sNAME char(20)
declare temptable cursor for
select coOwerShipID,coOwnerName from coOwnerShip (可加条件)
open temptable
fetch from temptable into @sID ,@sNAME
while @@fetch_status=0
begin
set @lvStr=@lvStr+ltrim(rtrim(@sID))+' '+@sNAME+' '
fetch from temptable into @sID ,@sNAME
end
close temptable
deallocate temptable
select @lvstr