通过赋予id返回更多数量值的函数 [英] function that returns more number of values by giving id

问题描述

对于我的应用程序

我需要编写一个函数，用commaseperated返回多个值

通过提供id

例如:输出:1,2,3,4,5,6 ------

for my application

i need to write a function that returns more than one value with commaseperated

by giving id

ex:output: 1,2,3,4,5,6------

推荐答案

可能对您有所帮助.

May be helpful to you.

Select STUFF((SELECT ' , '+ LRT.LRNo
        FROM TRNS.LorryReceipt LRT
        FOR XML PATH('')), 1, 2, '') AS [LRNo]

我假设您具有父子表，并且正尝试获取给定父表ID的所有匹配子表，请在下面尝试以下功能:

I am assuming you have parent-child tables and you are trying to get all matching children for a given parent table ID, try this function below:

CREATE FUNCTION GetCSVId(@IdParent int)	
	RETURNS VARCHAR(1000)	
AS
BEGIN	
	DECLARE csv VARCHAR(1000)
	
	SELECT @csv =COALESCE(@csv+',','') + value
	from CHILDTABLE
	WHERE IDParent = @IdParent
	
	RETURN @csv
END

尝试:

SELECT SUBSTRING(
(SELECT ',' + CONVERT(varchar, myValue) FROM myTable WHERE Id=666
FOR XML PATH('')),2,100000) AS CSV

这篇关于通过赋予id返回更多数量值的函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！