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:
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
Post a Comment