假如我有数组:a(1)=111,a(2)=222,a(3)=333……
w我要把数组传入存储过程,但SQLSERVER不支持数组,搜索baidu,找到一个很强的方法:
1、先把数组转成一个以逗号分隔的字符串a='111,222,333,444,……'
2、把字符串转换成一个用union连起来的select语句:
select '111' as a union select '222' as a union select '333' as a union select '444' as a……
则此语句可以得到以下结果:
a
----------
111
222
333
444
.
.
.
.
然后把结果插入到临时表中
declare @string varchar(80)
declare @sqlSTR2TABLE varchar(1000)
set @string='111,222,333,444,555,666,777,888'
set @sqlSTR2TABLE='select ''' + replace (@string,',',''' as caller_id union select ''') + ''''
exec(@sqlSTR2TABLE)