JSON (SQL2016 CTP2)

Question

JSON (SQL2016 CTP2)

psingla

Hall of Fame

Points: 3840
More actions
June 19, 2015 at 12:09 am

#299346

Comments posted to this topic are about the item JSON (SQL2016 CTP2)
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 1

Bleeding edge questions, I like it

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Good question. Nice to have a question on something as new as this.

Also nice to see we will soon have a civilized alternative in SQL Server to that awful XML.

Tom

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 3

Easy question as I have read yesterday the article about this topic. at[/url]

And I was surprised to see twice the same topic with the same author.

I am not liking JSON but I am interested by the next SQL Server version.

According this blog , it seems that these both FOR JSON clauses will not be alone in the RTM version.

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

TomThomson (6/19/2015)
Good question. Nice to have a question on something as new as this.
Also nice to see we will soon have a civilized alternative in SQL Server to that awful XML.

Gr8 news

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Arno Kwetters Hall of Fame Points: 3876 More actions · Answer 5

Finally we got native JSON in SQL Server !

I was waiting for that option a long time.

Thanks for pointing at that for me important option.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

TomThomson (6/19/2015)
Good question. Nice to have a question on something as new as this.
Also nice to see we will soon have a civilized alternative in SQL Server to that awful XML.

Amen to that. JSON isn't as bloated as XML, but I admit I'm curious about performance. I hope the implementation of it is better than the implementation of XML.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 7

Nice question. Good to know the difference in modes for JSON and XML.

This is first QotD touching SQL 2016.

Igor Micev,My blog: www.igormicev.com

akljfhnlaflkj SSC Guru Points: 76202 More actions Follow · Answer 8

akljfhnlaflkj

SSC Guru

Points: 76202

June 25, 2015 at 7:00 am

#1808032

A little ahead of me. We're not there yet.

JSON (SQL2016 CTP2)

Cookies on SQLServerCentral