create function F_Test(@parm char(20))
returns varchar(8000)
as
begin
declare @r varchar(8000)
set @r=''
select @r=@r+','+rtrim(name)
from table1
go-----如果把此行和下面一行去掉则可正常运行,怪不怪?
return(stuff(@r,1,1,''))
end
或者就把go去掉.
returns varchar(8000)
as
begin
declare @r varchar(8000)
set @r=''
select @r=@r+','+rtrim(name)
from table1
go-----如果把此行和下面一行去掉则可正常运行,怪不怪?
return(stuff(@r,1,1,''))
end
或者就把go去掉.
create function dbo.F_Test(@parm char(20))
returns varchar(8000)
as
begin
declare @r varchar(8000)
set @r=''
select @r=@r+','+rtrim(content)
from table1
return(stuff(@r,1,1,''))
end
go
-----如果把此行和下面一行去掉则可正常运行,怪不怪?
print dbo.F_Test('asdf')
go
drop function dbo.F_Test
select @r=@r+','+rtrim(content)
改为
select @r=@r+','+rtrim(name)
(因为我建的table1表的结构与你的不一样)
returns varchar(8000)
as
begin --A
declare @r varchar(8000)
set @r=''
select @r=@r+','+rtrim(name)
from table1
return(stuff(@r,1,1,''))
endgo
print dbo.F_Test('asdf')
go
drop function F_Test
困惑中......
from table1当Table1中有多条记录时能实现吗
from 不存在这个表---上面这行也成立,你说怪不怪???但一调用这个函数就出错了,---是不是这个东西不重要,‘别陷入语法的细节中去’???‘思想才是最重要的’???