How to create a table type in Sql Server 2005

问题:

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'.

回答1:

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

回答2:

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