求一句sql语句~!高手请进!!!!

[zjl0319]

有一个表如下
A:
userName ff dd
-------- --- ----
张三 a b
张三 b a
...
我想在控制台输出:
张三信息:ab,ba,..怎么写!

[power19994894]

放到前台整吧。

[dh20156]

TRY:

Select [username],MIN(ut)+IIF(COUNT(*)=1,'',','+MAX(ut)) As [fd] From(Select [username],[ff]+[dd] As [ut] From [A]) Group by [username]

[shuijing_love]

/*--检测是否存在--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='F_GetWent')
DROP FUNCTION F_GetWent
GO

CREATE 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,...
*/

[zjl0319]

谢谢各位! 我试一下,如果可以实现马上结分

[zjl0319]

谢谢啦!