It's a powerful advantage that you can use any T-SQL function and query clause to query JSON documents. SQL Server and SQL Database don't introduce any constraints in the queries that you can use to ...

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

(SQL Server 2000)I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.I then have a correlated subquery that runs against the temp table.Now when ...