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. This page has been read 4,527 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

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)