Arrays in SQL Server
SQL Server 2000 and Transact-SQL have many features, but one of the most often asked for features has been the implementation of some sort of array data type. This basic programming concept is notably absent from the development platform and results in many headaches and frustrations for DBAs. New author Alex Grinberg brings us his techniques for simulating arrays in SQL Server 2000.
http://www.sqlservercentral.com/columnists/aGrinberg/thearrayinsqlserver2000.asp
Passing Array as Stored procedure parameters
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
Alter Table Syntax