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

bitsmed note - Time query problem (0 Replies)

Move columns into rows for same items (1 Reply)

tools sql query, auto schedule+ auto save txt file (0 Replies)

Sql query by time range + shop (0 Replies)

output txt file (8 Replies)

Anyone can help edit this query ? (0 Replies)

get last record (2 Replies)

query with parameter (2 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 -