SQL Server Msg 195, Level 15, State 10, Line 6 'String_Agg' is not a recognized built-in function name

lpwwtiir 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(365)

I am trying to execute string_Agg() function at below mentioned version.

But SQL Server throws this error:
Msg 195, Level 15, State 10, Line 6
'String_Agg' is not a recognized built-in function name

Versions used:

SQL Server Management Studio                    15.0.18131.0
Microsoft Analysis Services Client Tools        15.0.1347.0
Microsoft Data Access Components (MDAC)         10.0.14393.0
Microsoft MSXML                                 3.0 6.0 
Microsoft Internet Explorer                     9.11.14393.0
Microsoft .NET Framework                        4.0.30319.42000
Operating System                                10.0.14393

Please help for any workaround for this.

sql-server

来源：https://stackoverflow.com/questions/72431017/msg-195-level-15-state-10-line-6-string-agg-is-not-a-recognized-built-in-fu

1条答案

按热度按时间

bf1o4zei1#

see the sql server version of the Target Sql Server, by running below command.

SELECT @@version

Or you can run below command to get information about Sql server

SELECT  
  SERVERPROPERTY('MachineName') AS ComputerName,
  SERVERPROPERTY('ServerName') AS InstanceName,  
  SERVERPROPERTY('Edition') AS Edition,
  SERVERPROPERTY('ProductVersion') AS ProductVersion,  
  SERVERPROPERTY('ProductLevel') AS ProductLevel;  
GO

if you see, STR_AGG() is supported only from SQL Server 2017(version 14.x) onwards.

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server Msg 195, Level 15, State 10, Line 6 'String_Agg' is not a recognized built-in function name

1条答案

相关问题

热门标签

最新问答