开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜