开发者

Error executing SQL Server CLR "hello world"

When running this sample

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

from SQl Manager (SQL Serve开发者_JS百科r 9) I get this error:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.

sp_configure 'clr enabled' is already set to 1 and the service was restarted.

What went wrong?

Thanks, P


(SQL Server 9)

User-defined table types are a feature introduced in SQL Server 2008, version 10.

CREATE TYPE in SQL Server 2005

CREATE TYPE in SQL Server 2008

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜