/*--检测是否存在--*/ IF EXISTS(SELECT * FROM sysobjects WHERE name='F_GetWent') DROP FUNCTION F_GetWent GOCREATE FUNCTION F_GetWent(@userName VARCHAR(11)) RETURNS NVARCHAR(2000) AS BEGIN DECLARE @S NVARCHAR(2000) SELECT @S = '' SELECT @S = @S + ',' +ff+dd FROM A WHERE userName=@userName SELECT @S = STUFF(@S, 1, 1, '') RETURN @S END GO DECLARE @info varchar(10) SELECT @info=dbo.F_GetWent('张三') FROM A print '张三信息:'+@info GO/* 张三信息:ab,ba,... */
/*--检测是否存在--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='F_GetWent')
DROP FUNCTION F_GetWent
GOCREATE FUNCTION F_GetWent(@userName VARCHAR(11))
RETURNS NVARCHAR(2000)
AS
BEGIN
DECLARE @S NVARCHAR(2000)
SELECT @S = ''
SELECT @S = @S + ',' +ff+dd FROM A WHERE userName=@userName
SELECT @S = STUFF(@S, 1, 1, '')
RETURN @S
END
GO
DECLARE @info varchar(10)
SELECT @info=dbo.F_GetWent('张三') FROM A
print '张三信息:'+@info
GO/*
张三信息:ab,ba,...
*/