I am trying to create a table type in sql server 2008 R2 for use in TVP in stored procs. But I am getting this error as

Incorrect syntax near the keyword 'AS'.

CREATE TYPE LocationTableType AS TABLE
( LocationName VARCHAR(50)
, CostRate INT );
GO

This is the MSDN example. Please help me in understanding what is going wrong.

Hi Pulkit,

That is perfect, i even tried myself it is working fine. Can you please check you do not have wild character before and after the query that may be causing the problem.

Looks like  you connected to SS2005 server or the database is set 80 or 90 compatibility level