Can we have array type data in sql server 2008
SQL Server 2005+ supports table-valued variables:
declare @arr table (col1 int)insert @arr (col1) values (3), (1), (4)These are equivalent to arrays.
You can use instead:
1. Table
2. Temporary table
3. Table variable (2005+)
4. Table-valued parameters (2008+)
User-defined tables:
If you want to learn more, this article is widely referenced:
http://www.sommarskog.se/arrays-in-sql-2008.html
Table-value parameters were introduced in SQL Server 2008.