将可变参数列表传递给 SqlServer2008 存储过程的理智/快速方法

2021-12-20 00:00:00 sql parameters sql-server-2008 sql-server stored-procedures

一个相当全面的大脑查询已经找到了一千零一种传递可变长度参数列表的方法，这些方法涉及以下方法:

A fairly comprehensive query of the brain has turned up a thousand and one ways to pass variable length parameter lists that involve such methods as:

  • 基于 CLR 的将字符串解析为整数列表的方法
  • 需要存在数字"表的表值函数 (wtf?)
  • 将数据作为 XML 传递
  • CLR based methods for parsing strings to lists of integers
  • Table valued functions that require the presence of a 'Numbers' table (wtf?)
  • Passing the data as XML

我们的要求是将两个可变长度的整数列表(~最多 20 个整数)传递给存储过程.上面列出的所有方法似乎都很有趣.

Our requirements are to pass two variable length lists of integers (~max 20 ints) to a stored procedure. All methods outlined above seem to smell funny.

这只是必须完成的方式，还是有更好的方法?

Is this just the way it has to be done, or is there a better way?

我刚刚找到了这个，它可能符合条件这个问题是骗人的

I've just found this, which may qualify this question as a dupe

推荐答案

是的，我肯定会看看 表值参数为此.作为附带的好处，它可以让您直接为您的程序内部使用一个漂亮、干净的基于集合的实现，而无需任何数据按摩.

Yes, I'd definitely look at Table Valued Parameters for this. As a side benefit, it may allow you to use a nice, clean set-based implementation for the innards of your procedure directly, without any data massaging required.

这里还有另一个参考资料..

相关文章