Shatha893

Untitled

Jul 27th, 2021
2,295
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DECLARE @DATA NVARCHAR(4000);
  2.  
  3. SET @DATA = N'{
  4.  
  5. {"message":"Hi Shiv, To get access please find the credentials with given query"}
  6.  
  7. }';
  8.  
  9. SELECT JSON_QUERY(@DATA) AS 'Result';
RAW Paste Data