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

By Bill Graziano on 26 March 2007 | 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.

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

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)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

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

Related Articles

Other Recent Forum Posts

Subscribe to SQLTeam.com

Resources