--测试数据
if object_id('TempTable') is not null drop table TempTable
go
create table TempTable(Cr_Id int, Cr_Message varchar(50))
insert TempTable select 1, 'abc'
union all select 2, '1f'
union all select 3, '9f'
union all select 4, 'd2f'
union all select 5, '3f'
--示例
declare @str varchar(255)
set @str=''
select @str=@str+Cr_Message
from (select top 3* from TempTable order by Cr_Id desc)t
print @str
if object_id('TempTable') is not null drop table TempTable
go
create table TempTable(Cr_Id int, Cr_Message varchar(50))
insert TempTable select 1, 'abc'
union all select 2, '1f'
union all select 3, '9f'
union all select 4, 'd2f'
union all select 5, '3f'
--示例
declare @str varchar(255)
set @str=''
select @str=@str+Cr_Message
from (select top 3* from TempTable order by Cr_Id desc)t
print @str
Create Table TempTable
(id Int Identity(1,1),
Cr_Message Varchar(50))
--插入数据
Insert TempTable Values('AAAA')
Insert TempTable Values('BBBB')
Insert TempTable Values('CCCC')
Insert TempTable Values('DDDD')
Insert TempTable Values('EEEE')
Insert TempTable Values('FFFF')
Insert TempTable Values('GGGG')
GO
--测试
Declare @varContent varchar(1000)
Set @varContent=''
Select Top 3 @varContent=@varContent+Cr_Message from TempTable Order By id Desc
Select @varContent
--删除测试环境
Drop Table TempTable
--结果
/*
GGGGFFFFEEEE
*/
如果是这样的话,可以用下面的.
--示例
declare @str varchar(255)
set @str=''
select @str=@str+Cr_Message+'\n\r'
from (select top 3* from TempTable order by Cr_Id desc)t
print @str
declare @str varchar(255)
set @str=''
select @str=@str+Cr_Message+char(0xa)
from (select top 3* from TempTable order by Cr_Id desc)t
print @str
declare @str varchar(255)
set @str=''
set @id=0
select @id=@id+1,
@str=@str+convert(varchar(2), @id)+','+Cr_Message+char(0xa)
from (select top 3* from TempTable order by Cr_Id desc)t
print @str
Create Table TempTable
(id Int Identity(1,1),
Cr_Message Varchar(50))
--插入数据
Insert TempTable Values('AAAA')
Insert TempTable Values('BBBB')
Insert TempTable Values('CCCC')
Insert TempTable Values('DDDD')
Insert TempTable Values('EEEE')
Insert TempTable Values('FFFF')
Insert TempTable Values('GGGG')
GO
--测试
Declare @varContent varchar(1000)
Set @varContent=''
Select Top 3 @varContent=@varContent+Char(13)+Cr_Message from TempTable Order By id Desc
Print @varContent
--删除测试环境
Drop Table TempTable
--结果
/*
GGGG
FFFF
EEEE
*/