存储过程处理数组参数的简单解决办…

1.declare @sql varchar(1024)

2.declare @key varchar(10)

3.set @key ='1'

4.set @sql='123,456,333,444'

5.select @sql = 'select '''+@key+''', '''+replace(@sql,',',''' union select '''+@key+''', ''')+''''

6.exec (@sql)

7.print ('insert into xxx(key,value) '+@sql)

<wbr></wbr>

<wbr></wbr>

运行结果：

1.insert into xxx(key,value) select '1', '123' union select '1', '456' union select '1', '333' union select '1', '444'

1     123

1        333

1        444

1        456