Can we have array type data in SQL Server 2008

Question

Can we have array type data in SQL Server 2008 currently I use a comma-separated value that needs to be considered as an array value

Answer 1

SQL Server 2005+ supports table variables:

declare @arr table (col1 int) insert @arr (col1) values (3), (1), (4) 

They are equivalent to arrays.

Answer 2

Instead, you can use:
1. Table
2. Temporary table
3. Variable table (2005+)
4. Tabular parameters (2008+)

Answer 3

User tables:

If you want to know more, this article is widely mentioned:

http://www.sommarskog.se/arrays-in-sql-2008.html

Table value options were introduced in SQL Server 2008.