试试这样:比如表名为test 序号为(ID)名称为(NAME)
declare @name varchar(4000)
set @name = ''
select @name = @name + ',' + name from test
set @name = right(@name,len(@name)-1)
select @name
declare @name varchar(4000)
set @name = ''
select @name = @name + ',' + name from test
set @name = right(@name,len(@name)-1)
select @name
declare @test varchar(4000)
set @test=''
select top 10 @test=@test+au_id from authors
print @test
from table
group by 序号 //可自动产生一个表扫描!
declare @name varchar(8000)
set @name = ''
select @name = @name + name from test
select @name
newyu1127(825新生) 的答案可以實現累加功能
webmin(webmin) 似乎理解錯了題意,但大致是這意思
xiongying860421(以学为主,兼学别样) 的答案是我最想要的,可惜這個語句不正確,就連語法都不對,我照著如下寫
declare @test varchar(4000)
select id,@test=@test+名稱 from test group by id出錯提示:A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations
AS
begin
declare @name varchar(8000)
set @name = ''
select @name = @name + name from TAB where id=@id
return @name
end
go
SELECT id,NAME=dbo.f_name_add(id) from tab group by id
---------------------------
li chen n1392
jing li m2421把Lname,Fname显示在一列上
select Fname+' '+Lname AS personname,productid
from table1personname productid
-----------------------
chen li n1392
li jing m2421