如何给SQL SERVER存储过程传递数组参数

请问下,如何给SQL SERVER存储过程传递数组参数
最新回答
灰尘往事

2024-10-23 08:35:37

但可用其它的方法来实现。
    1. You could simulate an array by passing one or more varchar(255) fields with comma-separated values and then use a WHILE loop with PATINDEX and SUBSTR to extract the values.
    1、你可以使用几个VARCHAR(255)字段来模拟数组,字段中用逗号分开各个数据,然后使用循环和PATINDEX和SUBSTR分开这些数据。
    2. The more usual way to do this would be to populate a temporary table with the values you need and then use the contents of that table from within the stored-procedure. Example of this below    2、通常这种方法需要为这些数据创建一个临时表,然后在存储过程使用表中的内容。如下例    create procedure mytest @MyParmTempTable varchar(30)  as  begin  -- @MyParmTempTable contains my parameter list...  这个变量是包含参数的表名    -- For simplicity use dynamic sql to copy into a normal temp table...
    create table #MyInternalList (
  list_item varchar( 2 ) not null  )    set nocount on    insert #MyInternalList
  select *
  from sysobjects

  insert #MyList values ( 'P' )    exec mytest "#MyList"    3. If all you wanted to do was use the array/list as input to an IN clause in a WHERE statement you could use :-    3、如果你想在IN子句里使用输入的数组参数可以这样做:    CREATE PROCEDURE sp_MyProcedure (@MyCommaDelimitedString