摘要:
方法一:--创建一个合并的函数 create function f_hb(@id int) returns varchar(8000) as begin declare @str varchar(8000) set @str = '' select @str = @str + ',' + cast(DepartID as varchar) from UserDept where UserID = @id set @str = right(@str , len(@str) - 1) return(@str) End go --调用自定义函数得到结果: sele.. 阅读全文