Error: Incorrect syntax near the keyword 'AS' on SQL Server 2005.
I got this error when I created SQL script from SQL Server 2008 and tried to run on SQL Server 2005.
CREATE TYPE EmployeeIDType AS TABLE
Cause: Table Type is not supported by SQL Server 2005, Table type introduced in new version of SQL Server 2008 and above.
AlterNet way to fulfill table type parameter requirement in SQL Server 2005 is to pass XML or use NVARCHAR(MAX) as input parameter
SQL Server 2005