How to create a table type in Sql Server 2005

Posted by Nikola Stjelja on Stack Overflow See other posts from Stack Overflow or by Nikola Stjelja
Published on 2010-04-09T09:27:29Z Indexed on 2010/04/09 9:53 UTC
Read the original article Hit count: 304

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about tsql

Related posts about sql-server-2005