declare @s varchar(8000) set @s=''select @s=@s+name from a1 print @s
--沒有這個函數﹐自己寫一個 CREATE FUNCTION [dbo].[F_Select] (@a as varchar(100)) RETURNS varchar(8000) AS BEGIN declare @s varchar(8000) set @s=''select @s=@s+[name] from a1 return @s END--調用 select dbo.F_Select('')
set @s=''select @s=@s+name from a1
print @s
CREATE FUNCTION [dbo].[F_Select] (@a as varchar(100))
RETURNS varchar(8000) AS
BEGIN
declare @s varchar(8000)
set @s=''select @s=@s+[name] from a1
return @s
END--調用
select dbo.F_Select('')