Passing an array of values to SQL Server (Stored Procedure) without parsing/string manipulation

By Bill Graziano on 26 March 2007 | 1 Comment | Tags: Dynamic SQL


Harsh sent us this one. He writes "Just came across the post on how to pass array of values without normal CSV parsing on Tony Rogerson's blog." Tony uses dynamic SQL to parse out the values in the string. Follow the link to Passing an array of values to SQL Server (Stored Procedure) without parsing/string manipulation...

Discuss this article: 1 Comment so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Using Dynamic SQL in Stored Procedures (7 March 2011)

Efficient and Dynamic Server-Side Paging with T-SQL (23 March 2004)

Introduction to Dynamic SQL (Part 2) (27 June 2001)

Introduction to Dynamic SQL (Part 1) (20 June 2001)

Dynamic Cross-Tabs/Pivot Tables (12 March 2001)

Implementing a Dynamic WHERE Clause (14 January 2001)

Other Recent Forum Posts

Last Working Day (0 Replies)

This should work right???? (0 Replies)

Finding last day date code (0 Replies)

Msg 4104 (54 Replies)

Query Help (1 Reply)

script running longer (3 Replies)

Passing Column as Parameter (1 Reply)

Duplicates in query (3 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -