blocks|key|417084|text|你需要使用逗号分隔的列表吗？在过去的几年中，我一直采用这种类型的想法，并传入了一个XML文件。openxml+"function“接受一个字符串并使其类似于xml，然后如果您使用该数据创建一个临时表，那么它就是可查询的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|417085|DECLARE+@idoc+int
DECLARE+@doc+varchar(1000)
SET+@doc+='
<ROOT>
<Customer+CustomerID="VINET"+ContactName="Paul+Henriot">
+++<Order+CustomerID="VINET"+EmployeeID="5"+OrderDate="1996-07-04T00:00:00">
++++++<OrderDetail+OrderID="10248"+ProductID="11"+Quantity="12"/>
++++++<OrderDetail+OrderID="10248"+ProductID="42"+Quantity="10"/>
+++</Order>
</Customer>
<Customer+CustomerID="LILAS"+ContactName="Carlos+Gonzlez">
+++<Order+CustomerID="LILAS"+EmployeeID="3"+OrderDate="1996-08-16T00:00:00">
++++++<OrderDetail+OrderID="10283"+ProductID="72"+Quantity="3"/>
+++</Order>
</Customer>
</ROOT>'
--Create+an+internal+representation+of+the+XML+document.
EXEC+sp_xml_preparedocument+@idoc+OUTPUT,+@doc
--+Execute+a+SELECT+statement+that+uses+the+OPENXML+rowset+provider.
SELECT++++*
FROM+++++++OPENXML+(@idoc,+'/ROOT/Customer',1)
++++++++++++WITH+(CustomerID++varchar(10),
++++++++++++++++++ContactName+varchar(20))|code-block|syntax|javascript|417086|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Do you need to use a comma separated list? The last couple of years, I've been taking this type of idea and passing in an XML file. The openxml "function" takes a string and makes it like xml and then if you create a temp table with the data, it is queryable.

<pre><code>DECLARE @idoc int
DECLARE @doc varchar(1000)
SET @doc ='
&lt;ROOT&gt;
&lt;Customer CustomerID="VINET" ContactName="Paul Henriot"&gt;
 &lt;Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00"&gt;
 &lt;OrderDetail OrderID="10248" ProductID="11" Quantity="12"/&gt;
 &lt;OrderDetail OrderID="10248" ProductID="42" Quantity="10"/&gt;
 &lt;/Order&gt;
&lt;/Customer&gt;
&lt;Customer CustomerID="LILAS" ContactName="Carlos Gonzlez"&gt;
 &lt;Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00"&gt;
 &lt;OrderDetail OrderID="10283" ProductID="72" Quantity="3"/&gt;
 &lt;/Order&gt;
&lt;/Customer&gt;
&lt;/ROOT&gt;'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
-- Execute a SELECT statement that uses the OPENXML rowset provider.
SELECT *
FROM OPENXML (@idoc, '/ROOT/Customer',1)
 WITH (CustomerID varchar(10),
 ContactName varchar(20))
</code></pre>

blocks|key|3256115|text|将逗号分隔的列表传递给返回表值的函数。在StackOverflow上的某个地方有一个MS示例，如果我现在能看到它，那就太糟糕了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3256116|3256117|+CREATE+PROCEDURE+getSomething+@keyList+varchar(4096)+AS+SELECT+*+FROM+mytbl+WHERE+name+IN+(fn_GetKeyList(@keyList))|blockquote|3256118|3256119|3256120|打电话给你-|3256121|3256122|+exec+getSomething‘约翰，汤姆，福，酒吧’|3256123|3256124|3256125|我猜Sybase应该也能做类似的事情吧？|3256126|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|U|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|K|3|L|5|E|7|Z|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

Pass the comma separated list into a function that returns a table value. There is a MS SQL example somewhere on StackOverflow, damned if I can see it at the moment.

<blockquote>
<pre><code>CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
SELECT * FROM mytbl WHERE name IN (fn_GetKeyList(@keyList))
</code></pre>
</blockquote>

Call with -

<blockquote>
<pre><code>exec getSomething 'John,Tom,Foo,Bar'
</code></pre>
</blockquote>

I'm guessing Sybase should be able to do something similar?

blocks|key|414565|text|关于Kevin将参数传递给将文本拆分成表的函数的想法，下面是我几年前实现的该函数。这是一种享受。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|414566|Splitting+Text+into+Words+in+SQL|offset|length|414567|entityMap|0|LINK|mutability|MUTABLE|url|http://www.madprops.org/blog/splitting-text-into-words-in-sql-revisited/^0|0|0|W|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Regarding Kevin's idea of passing the parameter to a function that splits the text into a table, here's my implementation of that function from a few years back. Works a treat.

<a href="http://www.madprops.org/blog/splitting-text-into-words-in-sql-revisited/" rel="nofollow noreferrer">Splitting Text into Words in SQL</a>

blocks|key|3256146|text|如果您使用的是Sybase+12.5或更早版本，则不能使用函数。解决方法可能是用这些值填充一个临时表，然后从那里读取它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3256147|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you're using Sybase 12.5 or earlier then you can't use functions. A workaround might be to populate a temporary table with the values and read them from there.

blocks|key|414855|text|这是一个快速而肮脏的方法，可能会很有用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|414856|select++*+
from++++mytbl+
where+++","+%2B+ltrim(rtrim(@keylist))+%2B+","+like+"%25,"+%2B+ltrim(rtrim(name))+%2B+",%25"|code-block|syntax|javascript|414857|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is a quick and dirty method that may be useful:

<pre><code>select * 
from mytbl 
where "," + ltrim(rtrim(@keylist)) + "," like "%," + ltrim(rtrim(name)) + ",%"
</code></pre>

blocks|key|417112|text|不确定它是否在ASE中，但在SQL+Anywhere中，sa_split_list函数从CSV中返回表。它有可选的参数来传递不同的分隔符(默认是逗号)和每个返回值的最大长度。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|417113|sa_split_list+function|offset|length|417114|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/html/dbrfen10/rf-sa-set-http-option.html^0|0|0|M|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Not sure if it's in ASE, but in SQL Anywhere, the sa_split_list function returns a table from a CSV. It has optional arguments to pass a different delimiter (default is a comma) and a maxlength for each returned value.

<a href="http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/html/dbrfen10/rf-sa-set-http-option.html" rel="nofollow noreferrer">sa_split_list function</a>

blocks|key|417116|text|exec+getSomething+'"John"，“Tom”“的问题是，它将”“John”，“Tom”“视为单个字符串，它只会匹配表中'"John"，”Tom“”的条目。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|417117|如果您不想像Paul的答案中那样使用临时表，那么可以使用动态sql。(假设为v12%2B)|417118|CREATE+PROCEDURE+getSomething+@keyList+varchar(4096)
AS
declare+@sql+varchar(4096)
select+@sql+=+"SELECT+*+FROM+mytbl+WHERE+name+IN+("+%2B+@keyList+%2B")"
exec(@sql)|code-block|syntax|javascript|417119|您需要确保@keylist中的项有引号，即使它们是单值。|417120|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The problem with the calls like this: exec getSomething '"John","Tom"' is that it's treating '"John","Tom"' as a single string, it will only match an entry in the table that is '"John","Tom"'.

If you didn't want to use a temp table as in Paul's answer, then you could use dynamic sql. (Assumes v12+)

<pre><code>CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
declare @sql varchar(4096)
select @sql = "SELECT * FROM mytbl WHERE name IN (" + @keyList +")"
exec(@sql)
</code></pre>

You will need to ensure the items in @keylist have quotes around them, even if they are single values.

blocks|key|411337|text|这在SQL中是有效的。在GetSomething过程中声明一个XML类型的变量，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|411338|DECLARE+@NameArray+XML+=+NULL|code-block|syntax|javascript|411339|存储过程的主体实现了以下内容：|411340|SELECT+*+FROM+MyTbl+WHERE+name+IN+(SELECT+ParamValues.ID.value('.','VARCHAR(10)')
FROM+@NameArray.nodes('id')+AS+ParamValues(ID))|411341|在调用存储过程之前，在调用SP以声明和初始化XML变量的SQL代码中：|411342|DECLARE+@NameArray+XML

SET+@NameArray+=+'<id><</id>id>Name_1<<id>/id></id><id><</id>id>Name_2<<id>/id></id><id><</id>id>Name_3<<id>/id></id><id><</id>id>Name_4<<id>/id></id>'|411343|使用您的示例，对存储过程的调用将是：|411344|EXEC+GetSomething+@NameArray|411345|我以前用过这种方法，它工作得很好。如果您想要快速测试，请将以下代码复制并粘贴到新查询中并执行：|411346|DECLARE+@IdArray+XML

SET+@IdArray+=+'<id><</id>id>Name_1<<id>/id></id><id><</id>id>Name_2<<id>/id></id><id><</id>id>Name_3<<id>/id></id><id><</id>id>Name_4<<id>/id></id>'

SELECT+ParamValues.ID.value('.','VARCHAR(10)')
FROM+@IdArray.nodes('id')+AS+ParamValues(ID)|411347|entityMap^0|C|C|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|18|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1A|8|@]|D|@]|E|$]]|$1|U|3|V|5|H|7|1B|8|@]|D|@]|E|$I|J]]|$1|W|3|X|5|6|7|1C|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|H|7|1D|8|@]|D|@]|E|$I|J]]|$1|10|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|11|$]]

This works in SQL. Declare in your <code>GetSomething</code> procedure a variable of type XML as such:

<pre><code>DECLARE @NameArray XML = NULL
</code></pre>

The body of the stored procedure implements the following:

<pre><code>SELECT * FROM MyTbl WHERE name IN (SELECT ParamValues.ID.value('.','VARCHAR(10)')
FROM @NameArray.nodes('id') AS ParamValues(ID))
</code></pre>

From within the SQL code that calls the SP to declare and initialize the XML variable before calling the stored procedure:

<pre><code>DECLARE @NameArray XML

SET @NameArray = '&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_1&lt;&lt;id&gt;/id&gt;&lt;/id&gt;&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_2&lt;&lt;id&gt;/id&gt;&lt;/id&gt;&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_3&lt;&lt;id&gt;/id&gt;&lt;/id&gt;&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_4&lt;&lt;id&gt;/id&gt;&lt;/id&gt;'
</code></pre>

Using your example the call to the stored procedure would be:

<pre><code>EXEC GetSomething @NameArray
</code></pre>

I have used this method before and it works fine. If you want a quick test, copy and paste the following code to a new query and execute:

<pre><code>DECLARE @IdArray XML

SET @IdArray = '&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_1&lt;&lt;id&gt;/id&gt;&lt;/id&gt;&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_2&lt;&lt;id&gt;/id&gt;&lt;/id&gt;&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_3&lt;&lt;id&gt;/id&gt;&lt;/id&gt;&lt;id&gt;&lt;&lt;/id&gt;id&gt;Name_4&lt;&lt;id&gt;/id&gt;&lt;/id&gt;'

SELECT ParamValues.ID.value('.','VARCHAR(10)')
FROM @IdArray.nodes('id') AS ParamValues(ID)
</code></pre>

blocks|key|411349|text|这有点晚了，但我在不久前遇到了这个问题，我找到了解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|411350|诀窍是使用双引号，然后用引号将整个字符串括起来。|411351|exec+getSomething+"""John"",""Tom"",""Bob"",""Harry"""|code-block|syntax|javascript|411352|修改proc，使表条目与字符串匹配。|411353|CREATE+PROCEDURE+getSomething+@keyList+varchar(4096)
AS
SELECT+*+FROM+mytbl+WHERE+@keyList+LIKE+'%25'%2Bname%2B'%25'+|411354|从ASE+12.5开始，我就开始生产这个了；我们现在是15.0.3。|411355|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

This is a little late, but I had this exact issue a while ago and I found a solution.

The trick is double quoting and then wrapping the whole string in quotes.

<pre><code>exec getSomething """John"",""Tom"",""Bob"",""Harry"""
</code></pre>

Modify your proc to match the table entry to the string. 

<pre><code>CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
SELECT * FROM mytbl WHERE @keyList LIKE '%'+name+'%' 
</code></pre>

I've had this in production since ASE 12.5; we're now on 15.0.3.

blocks|key|3469374|text|谈到@Abel提供了什么，帮助我的是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3469375|我的目的是获取最终用户从SSRS输入的任何内容，并在我的where子句中将其用作in+(SELECT)，显然@ICD_VALUE_RPT将在我的数据集查询中被注释掉。|3469376|DECLARE+@ICD_VALUE_RPT+VARCHAR(MAX)+SET+@ICD_VALUE_RPT+=+'Value1,+Value2'
DECLARE+@ICD_VALUE_ARRAY+XML+SET+@ICD_VALUE_ARRAY+=+CONCAT('<id>',+REPLACE(REPLACE(@ICD_VALUE_RPT,+',',+'</id>,<id>'),'+',''),+'</id>')|code-block|syntax|javascript|3469377|然后，在我的WHERE中，我添加了：|offset|length|style|CODE|3469378|(PATS_WITH_PL_DIAGS.ICD10_CODE+IN+(SELECT+ParamValues.ID.value('.','VARCHAR(MAX)')+FROM+@ICD_VALUE_ARRAY.nodes('id')+AS+ParamValues(ID))
OR+PATS_WITH_PL_DIAGS.ICD9_CODE+IN+(SELECT+ParamValues.ID.value('.','VARCHAR(MAX)')+FROM+@ICD_VALUE_ARRAY.nodes('id')+AS+ParamValues(ID))
)|3469379|entityMap^0|0|0|0|6|5|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@$K|W|L|X|M|N]]|9|@]|A|$]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

To touch on what @Abel provided, what helped me out was:

My purpose was to take what ever the end user inputted from SSRS and use that in my where clause as an In (SELECT)
Obviously @ICD_VALUE_RPT would be commented out in my Dataset query. 

<pre><code>DECLARE @ICD_VALUE_RPT VARCHAR(MAX) SET @ICD_VALUE_RPT = 'Value1, Value2'
DECLARE @ICD_VALUE_ARRAY XML SET @ICD_VALUE_ARRAY = CONCAT('&lt;id&gt;', REPLACE(REPLACE(@ICD_VALUE_RPT, ',', '&lt;/id&gt;,&lt;id&gt;'),' ',''), '&lt;/id&gt;')
</code></pre>

then in my <code>WHERE</code> i added:

<pre><code>(PATS_WITH_PL_DIAGS.ICD10_CODE IN (SELECT ParamValues.ID.value('.','VARCHAR(MAX)') FROM @ICD_VALUE_ARRAY.nodes('id') AS ParamValues(ID))
OR PATS_WITH_PL_DIAGS.ICD9_CODE IN (SELECT ParamValues.ID.value('.','VARCHAR(MAX)') FROM @ICD_VALUE_ARRAY.nodes('id') AS ParamValues(ID))
)
</code></pre>

blocks|key|3469381|text|试试这个方法。这对我很管用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3469382|@itemIds+varchar(max)

CREATE+PROCEDURE+getSomething+@keyList+varchar(4096)
AS
SELECT+*+FROM+mytbl+WHERE+name+IN+(SELECT+Value+FROM+[Global_Split]+(@itemIds,','))|code-block|syntax|javascript|3469383|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this way. Its works for me.

<pre><code>@itemIds varchar(max)

CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
SELECT * FROM mytbl WHERE name IN (SELECT Value FROM [Global_Split] (@itemIds,','))
</code></pre>

So I have a Sybase stored proc that takes 1 parameter that's a comma separated list of strings and runs a query with in in an IN() clause:

<pre><code>CREATE PROCEDURE getSomething @keyList varchar(4096)
AS
SELECT * FROM mytbl WHERE name IN (@keyList)
</code></pre>

How do I call my stored proc with more than 1 value in the list?
So far I've tried 

<pre><code>exec getSomething 'John' -- works but only 1 value
exec getSomething 'John','Tom' -- doesn't work - expects two variables
exec getSomething "'John','Tom'" -- doesn't work - doesn't find anything
exec getSomething '"John","Tom"' -- doesn't work - doesn't find anything
exec getSomething '\'John\',\'Tom\'' -- doesn't work - syntax error
</code></pre>

EDIT: I actually found this <a href="http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm" rel="noreferrer">page</a> that has a great reference of the various ways to pas an array to a sproc

How to pass a comma separated list to a stored procedure?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

所以我有一个Sybase存储的proc，它接受一个参数，该参数是一个逗号分隔的字符串列表，并在IN()子句中使用in运行查询：CREATE PROCEDURE getSomething @keyList varchar(4096)ASSELECT * FROM mytbl WHERE name IN (@keyList...

问如何将逗号分隔的列表传递给存储过程？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将逗号分隔的列表传递给存储过程？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将逗号分隔的列表传递给存储过程？
EN