Geek Answers Handbook

SSDT does not recognize STRING_SPLIT in SQL Server 2016

Try using the STRING_SPLIT function of SQL Server 2016 in a stored procedure. It correctly analyzes SSMS. But in SSDT (latest version), the function cannot be solved, so the project cannot be compiled. Does anyone know how to solve this? Thank.

+4
source share
1 answer

This is a known bug in SSDT, and we have a work item to fix this. Unfortunately, the only workaround I can offer is to remove STRING_SPLIT from the stored procedure definition and then change the stored procedure definition as an action after the script is deployed.

+1
source

More articles:


All Articles