STRING_AGG is not a recognized built-in function name

Luke101 Published at Dev

186

Luke101

I've downloaded and installed SQL Server 2016. When I attempted to use the STRING_AGG function I receive this error. Here is my code:

SELECT STRING_AGG(cast(FieldNumber AS VARCHAR(100)), ',')
FROM Fields

I've installed SQL Server 2016 and SP1. Is there anything else I need to do. Here is the feature I am trying to use. String Agg

Pரதீப்

STRING_AGG is not introduced in SQL SERVER 2016.

It is introduced in SQL SERVER vNext. In the MSDN link you have provided it is mentioned THIS TOPIC APPLIES TO : SQL Server (starting with vNext) not SQL SERVER 2016. It is a much needed feature I wish they add it in any future releases

In case you are wondering what is vNext

SQL Server vNext represents a major step towards making SQL Server a platform that enables choices of development languages, data types, on-premises and in the cloud, and across operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. SQL Server vNext also includes the features added in SQL Server 2016 service packs

For more info check here

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-25

Comments

0 comments

In postgres, how to sort on, among others, a result value of a string_agg function, without selecting that field? Subquery not possible

TOP Ranking

Article

STRING_AGG is not a recognized built-in function name

STRING_AGG is not a recognized built-in function name

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

grouping by column variables and appending a new variable based on condition

Vector input in shiny R and then use it

Can a 32-bit antivirus program protect you from 64-bit threats

Python Read Directory And Output to CSV

Remove adjacent duplicates in linked list in C

Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use

Json Schema - Conditional Evaluation with RegEx

Getting 502 Bad Gateway Error While Deploying WordPress On Dockerized Lemp?

JMeter: Why get error when try to save test plan

Group boxplot data while keeping their individual X axis labels in ggplot2 in R

How to how increase/decrease compared to adjacent cell

How to keep curl session alive between two php processes?

In Pandas UnicodeDecodeError Cannot decode Unicode Ascii in JSON file using pandas.read_json()

MTKView Displaying Wide Gamut P3 Colorspace

BigQuery - concatenate ignoring NULL

Error in v-on handler (Promise/async): "TypeError: Cannot read property 'data' of undefined" // undefined

An unhandled exception occurred: Collection "@angular/material" cannot be resolved

How to call angular controller scope function from directive with parameters?