create function f_c(@buyid varchar(10))
returns varchar(8000)
as
begin
declare @char varchar(8000)
set @char=''
select @char=@char+clientname+' ' from tb where buyid=@buyid
return left(@char,len(@char)-1)
endgocreate function f_t(@buyid varchar(10))
returns varchar(8000)
as
begin
declare @char varchar(8000)
set @char=''
select @char=@char+tel+' ' from tb where buyid=@buyid
return left(@char,len(@char)-1)
endgoselect distinct BuyId,dbo.f_c(BuyId),dbo.f_t(BuyId) from tb
returns varchar(8000)
as
begin
declare @char varchar(8000)
set @char=''
select @char=@char+clientname+' ' from tb where buyid=@buyid
return left(@char,len(@char)-1)
endgocreate function f_t(@buyid varchar(10))
returns varchar(8000)
as
begin
declare @char varchar(8000)
set @char=''
select @char=@char+tel+' ' from tb where buyid=@buyid
return left(@char,len(@char)-1)
endgoselect distinct BuyId,dbo.f_c(BuyId),dbo.f_t(BuyId) from tb
解决方案 »
- SQLSERVER附加数据库时错误 5123
- 怎样在查询分析器中查看varbinary数据内容?
- 想了很久,不想放弃的问题!!求解决方法!!!'一个数据汇总的问题'&能力有限,几天了没有解决.拜求各位高人!!!!&
- 急救,一个朋友在深圳人才市场,问 sql server 2000 中的 jobs 是什么意思?谢谢!
- 如何判定当天是否月初第一个星期和月底最后一个星期的其中一天
- 我想判断一个SQL的结果有没有记录,出现错误
- SQLSERVER2005下并发事务时的错误!求助啊!!!!
- Server2000简体中文4in1版---是个试用版吗
- 关于数据导入的问题
- 关于MS -SQL 2005 Datebase table index 问题请教
- 高手请进,不好意思今天分用了 明天补上 关于数据并发问题
- 如何确定一个role 是否存在?
(BuyId int,clientName varchar(20),tel varchar(50))
insert t
select 24,'xu','123,124,111' union all
select 24,'zhang','1110 135 111' union all
select 24,'张山','010-121212'
go
create function f_he(@id int,@col int)
returns varchar(100)
as
begin
declare @sql varchar(100)
set @sql=''
if @col=0
select @sql=@sql+' '+tel from t where BuyId=@id
else
select @sql=@sql+' '+clientName from t where BuyId=@id
return(stuff(@sql,1,1,''))
end
goselect BuyId,dbo.f_he(BuyId,1) as clientName,dbo.f_he(BuyId,0) as tel from t group by BuyIddrop table t
drop function f_he