Arrays and Lists in SQL Server

An SQL text by Erland Sommarskog, SQL Server MVP.

Introduction

In the public forums for SQL Server, you often see people asking How do I use arrays in SQL Server? Or Why does SELECT * FROM tbl WHERE col IN (@list) not work? This text describes several methods to do this, both good and bad ones. I also present data from performance tests of the various methods.

Read more...