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: 359
        
tsql
|sql-server-2005
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