开发者

Error executing SQL Server CLR "hello world"

开发者 https://www.devze.com 2023-02-25 09:28 出处:网络
When running this sample CREATE TYPE LocationTableType AS TABLE ( LocationName VARCHAR(50) , CostRate INT )

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

精彩评论

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