Skip to content

Instantly share code, notes, and snippets.

@MarshalOfficial

MarshalOfficial/jsonval.sql

Created July 20, 2022 06:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save MarshalOfficial/47b6cd73dfe50f614a262df039da1b1b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save MarshalOfficial/47b6cd73dfe50f614a262df039da1b1b to your computer and use it in GitHub Desktop.
Download ZIP
json value sql server
Raw
jsonval.sql
--select top 10 JSON_QUERY((select [value] from OPENJSON(rabbit_message) where Id=Id),'$.MessageId') AS test,*
--from [dbo].[message_logs] (nolock)
--where 1=1
--select top 10 (select [value] from OPENJSON(rabbit_message)) AS test,*
--from [dbo].[message_logs] (nolock)
--where 1=1
select top 10 JSON_Value((select [value] from OPENJSON(rabbit_message) where Id=Id),'$.MessageId') AS test,*
from [dbo].[message_logs] (nolock)
where 1=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment