但可用其它的方法来实现。 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