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
(
ID
Int
)
GO
|
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
Oracle
