SQLTeam.com Logo

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

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

Written by Bill Graziano on 26 March 2007

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.