How to create a table type in Sql Server 2005

Question

Hi, I'm trying to create a table type in sql server 2005.

Here is what my code looks like:

    CREATE TYPE NameResourceType AS TABLE
(
   ID int, 
   [Value] Varchar(256) 
)
GO

I receive the following error:

Incorrect syntax near the keyword 'AS'.

Answer 1

New in SQL Server 2008... "Table-Valued Parameters"

CREATE TYPE in SQL Server 2005 refers to "simple" user defined data types only... notice the difference in the SQL Server 2008 CREATE TYPE

Answer 2

Table alias data types & Table-Valued parameters were introduced in SQL Server 2008 so are not available in prior versions.