Click here to Skip to main content
14,240,857 members
   

Database

 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 4:45
memberjoost.versteegen7-Feb-19 4:45 
AnswerRe: update temp table with results from sub query (actually it is a function) Pin
Richard Deeming7-Feb-19 8:34
mveRichard Deeming7-Feb-19 8:34 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 11:20
memberjoost.versteegen7-Feb-19 11:20 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 20:33
memberjoost.versteegen7-Feb-19 20:33 
QuestionTables left and right Pin
Member 141362635-Feb-19 5:21
memberMember 141362635-Feb-19 5:21 
AnswerRe: Tables left and right Pin
Richard MacCutchan5-Feb-19 6:10
protectorRichard MacCutchan5-Feb-19 6:10 
AnswerRe: Tables left and right Pin
ZurdoDev7-Feb-19 4:41
professionalZurdoDev7-Feb-19 4:41 
QuestionUsing JSON functions with Always Encrypted data in SSMS Pin
Hypermommy4-Feb-19 6:06
memberHypermommy4-Feb-19 6:06 
I have an Azure SQL database that uses the Always Encrypted functionality. In this database I have a column called entryObject. It is an nvarchar field containing JSON data. It is encrypted using a Randomized encryption type.

I am currently writing SQL that should us the JSON_MODIFY function to update this data as well as unencrypted data in another table. I would like to have all of this functionality wrapped in a transaction and in a stored procedure. This way, my C# code can call this one stored proc and, if successful, I'll know that all data was updated successfully. However, any time I try to use the JSON_MODIFY function or even JSON_QUERY with my encrypted entryObject column's data, I get an error stating

Argument data type nvarchar(max) encrypted with (encryption_type = 'RANDOMIZED', ...  is invalid for argument 1 of json_query function.


How can I use JSON_MODIFY to change one of the values in this encrypted JSON?

Thanks in advance for any assistance you can give.
Denise

AnswerRe: Using JSON functions with Always Encrypted data in SSMS Pin
Richard Deeming4-Feb-19 9:20
mveRichard Deeming4-Feb-19 9:20 
GeneralRe: Using JSON functions with Always Encrypted data in SSMS Pin
Hypermommy6-Feb-19 2:38
memberHypermommy6-Feb-19 2:38 
Questiondatabase Pin
Member 141284154-Feb-19 6:03
memberMember 141284154-Feb-19 6:03 
AnswerRe: database Pin
Jörgen Andersson4-Feb-19 8:41
protectorJörgen Andersson4-Feb-19 8:41 
QuestionHaving difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 2:37
memberpaul4everyone28-Jan-19 2:37 
AnswerRe: Having difficulty to replicate entries in SQL query result Pin
Richard MacCutchan28-Jan-19 2:56
protectorRichard MacCutchan28-Jan-19 2:56 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 4:20
memberpaul4everyone28-Jan-19 4:20 
SuggestionRe: Having difficulty to replicate entries in SQL query result Pin
ZurdoDev28-Jan-19 4:48
professionalZurdoDev28-Jan-19 4:48 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 6:54
memberpaul4everyone28-Jan-19 6:54 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Richard MacCutchan28-Jan-19 6:01
protectorRichard MacCutchan28-Jan-19 6:01 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 6:51
memberpaul4everyone28-Jan-19 6:51 
AnswerRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes28-Jan-19 11:02
memberMycroft Holmes28-Jan-19 11:02 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone28-Jan-19 15:02
memberpaul4everyone28-Jan-19 15:02 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes29-Jan-19 10:58
memberMycroft Holmes29-Jan-19 10:58 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone31-Jan-19 10:50
memberpaul4everyone31-Jan-19 10:50 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
Mycroft Holmes31-Jan-19 11:15
memberMycroft Holmes31-Jan-19 11:15 
GeneralRe: Having difficulty to replicate entries in SQL query result Pin
paul4everyone2-Feb-19 19:03
memberpaul4everyone2-Feb-19 19:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.