November 1, 2017 at 9:45 am
Greetings, all.
I am working with a database project in Visual Studio.Enterprise 2015 & SQL Server 2016. I constructed some procedures & functions using the new JSON functionality. They work in SQL Server (with compatibility level 130.) However, if I add those code components to my Visual Studio project & try to build the solution, it fails, generating all kinds of syntax errors. Looking online, the only thing I can find is that there may be an as-yet-not-completely-fixed issue with OPENJSON in Visual Studio.
Has anyone here encountered this issue? Do you have a solution, workaround, etc.?
Thanks,
Randy
P.S. I did submit this question also in the SSDT forum, but the activity in that forum appears low so I submitted it in this forum as well.
November 1, 2017 at 10:45 am
wittr - Wednesday, November 1, 2017 9:45 AMGreetings, all.
I am working with a database project in Visual Studio.Enterprise 2015 & SQL Server 2016. I constructed some procedures & functions using the new JSON functionality. They work in SQL Server (with compatibility level 130.) However, if I add those code components to my Visual Studio project & try to build the solution, it fails, generating all kinds of syntax errors. Looking online, the only thing I can find is that there may be an as-yet-not-completely-fixed issue with OPENJSON in Visual Studio.
Has anyone here encountered this issue? Do you have a solution, workaround, etc.?
Thanks,
RandyP.S. I did submit this question also in the SSDT forum, but the activity in that forum appears low so I submitted it in this forum as well.
I created a new database in SSDT 2015 and added a single proc (stolen from BOL):CREATE PROCEDURE dbo.Proc1
AS
DECLARE @jsonInfo NVARCHAR(MAX);
DECLARE @town NVARCHAR(32);
SET @jsonInfo
= N'{
"info":{
"type":1,
"address":{
"town":"Bristol",
"county":"Avon",
"country":"England"
},
"tags":["Sport", "Water polo"]
},
"type":"Basic"
}';
SET @town = JSON_VALUE(@jsonInfo, '$.info.address.town');
SELECT @town;
This builds successfully. Can you provide an example of something which fails?
Can you also confirm that the target platform for the project has been set to SQL Server 2016?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 1, 2017 at 12:02 pm
Hi,
Issue has been resolved by a teammate. If you go into the Properties for the database project in Visual Studio, you can set Target Platform to SQL Server 2016 & on a sub-screen you can set the Compatibility Level to 130. That resolved the build issues.
November 1, 2017 at 1:20 pm
wittr - Wednesday, November 1, 2017 12:02 PMHi,
Issue has been resolved by a teammate. If you go into the Properties for the database project in Visual Studio, you can set Target Platform to SQL Server 2016 & on a sub-screen you can set the Compatibility Level to 130. That resolved the build issues.
Did you notice my comment which already suggested this?
Anyhow, glad it's working now.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply