SQL 4 CDS v8 Released


The latest update to SQL 4 CDS introduces support for Common Table Expressions (CTEs) and enhanced JSON functionality. CTEs allow for easier reuse of subqueries and make queries easier to understand and maintain. Recursive CTEs are particularly useful for querying hierarchical data structures. The update also includes expanded JSON support, with functions like OPENJSON, JSON_QUERY, and ISJSON. These functions allow for extracting multiple values from JSON strings. Other improvements include the IGNORE_DUP_KEY query hint, the ability to preserve comments when formatting queries, a "Yes To All" option for confirmation messages, and the ability to copy record URLs directly from the results grid.


Article 17m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time