Wednesday, September 03, 2014

Error: Incorrect syntax near the keyword 'AS' on SQL Server 2005.

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

1 comment:

moshrabbi121 said...

Aw, this was a very nice post. In thought I wish to put in writing like this additionally – taking time and actual effort to make a very good article… however what can I say… I procrastinate alot and under no circumstances seem to get something done. online casino games