See ‘ Consuming hierarchical JSON documents in SQL Server using OpenJSON‘ which I wrote more recently) (note: You can now do this rather more easily using SQL Server 2016’s built-in JSON support. Sometimes, you just need to do something inappropriate in TSQL. ‘Oh yes’, will chime in the application thought police, ‘this is far better done in the application or with a CLR.’ Not necessarily. You can do it but it is not a pretty sight but why would you ever want to do it anyway? Surely, if anything was meant for the ‘application layer’ in C# or VB.net, then this is it. TSQL isn’t really designed for doing complex string parsing, particularly where strings represent nested data structures such as XML, JSON, YAML, or XHTML. ![]() Consuming JSON Strings in SQL Server - Simple Talk
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |