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 k开发者_JAVA百科eyword 'AS'.
Table alias data types & Table-Valued parameters were introduced in SQL Server 2008 so are not available in prior versions.
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
精彩评论