Click here to Skip to main content
15,921,295 members
Articles / Database Development / SQL Server

SQL Wizardry Part Four - Passing Lists of Data to SQL Server

Rate me:
Please Sign up or sign in to vote.
4.74/5 (19 votes)
12 Jan 2014CPOL8 min read 32.2K   299   33  
Ways to pass an arbitrary list of values to SQL Server
In this article, we will take a look at how to pass a list of values into a stored proc and use it to select or insert data. We will look at three ways of doing this, and discuss the pros and cons of each.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
Australia Australia
Programming computers ( self taught ) since about 1984 when I bought my first Apple ][. Was working on a GUI library to interface Win32 to Python, and writing graphics filters in my spare time, and then building n-tiered apps using asp, atl and asp.net in my job at Dytech. After 4 years there, I've started working from home, at first for Code Project and now for a vet telemedicine company. I owned part of a company that sells client education software in the vet market, but we sold that and I worked for the owners for five years before leaving to get away from the travel, and spend more time with my family. I now work for a company here in Hobart, doing all sorts of Microsoft based stuff in C++ and C#, with a lot of T-SQL in the mix.

Comments and Discussions