Ok, I'm trying to write a query in a stored procedure in SQL Server 2000 ... situations I construct a string that contains the query and then use the exec() function to execute the query.< ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Because a JSON string equates to a plain text string, SQL Server and any other relational database ... then you must resort to the JSON_QUERY function. As obvious as it might sound, querying the ...