34,873
社区成员
发帖
与我相关
我的任务
分享看看这个聚合函数错在哪里？
''''''''''''''''''''''''''
表product
user_id product_name
''''''''''''''''''''''''''''''''''''''''
CREATE function mystr(@user_id varchar(10))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(product_name) from product
where user_id=@user_id
set @str=right(@str,len(@str)-1)
return @str
end
表product
user_id product_name
''''''''''''''''''''''''''''''''''''''''
CREATE function mystr(@user_id varchar(10))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(product_name) from product
where user_id=@user_id
set @str=right(@str,len(@str)-1)
return @str
end
...全文
请发表友善的回复…
发表回复
zjcxc 元老 2004-01-07
- 打赏
- 举报
CREATE function mystr(@user_id varchar(10))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(product_name) from product
where [user_id]=@user_id --user_id是系统函数,用[]包含起来
set @str=right(@str,len(@str)-1)
return @str
end
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(product_name) from product
where [user_id]=@user_id --user_id是系统函数,用[]包含起来
set @str=right(@str,len(@str)-1)
return @str
end
