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

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

Query performance Call Center data (20h)

Looking for on Premises tool to read data from SQL logs and populate data warehouse (1d)

Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (1d)

Working with multiple WHERE statements (1d)

Create a new field value that shows a difference in value from 2 fields (3d)

Hierarchy wise Sales Targets (3d)

Get the MaxDate in results (5d)

Switch Statement within a SSRS SQL Expression (6d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site