Can we have array type data in sql server 2008

Can we have array type data in sql server 2008
currently i am using comma seperated value to be treated as array value

  • The database cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported
  • Subtract two time values in ms sql server 2008
  • With SQL Server add x number of days to a date in sql but also pass in the number of business days in a week
  • Use of SqlParameter in SQL LIKE clause not working
  • Warning: An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll.
  • how to convert Mdf/ldf database files to .bak file (db restore) using T-SQL or .net code
  • 3 Solutions collect form web for “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:

    Table-value parameters were introduced in SQL Server 2008.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.