pivot on始终加密列 [英] pivot on Always encrypt columns

问题描述

您好

我正在尝试将键值对数据从始终加密的sql表PIVOT到列数据。不幸的是，数据仅处于加密模式。

I am trying to PIVOT key value pair data to column data from a Always encrypted sql table. Unfortunately the data is in encrypted mode only.

是否可以在AE数据上使用PIVOT。

Is it possible to use PIVOT on AE data.

我的查询就像

SELECT
    Id, col1, col2, col3...
FROM
    (
        SELECT
            Id, [Key], [Value] 
        FROM dbo.AETable
    ) AS Src
PIVOT
    (
    MIN([Value])
    FOR [Key] IN
        (
            Id, col1, col2, col3....
        )
    ) AS pvt

谢谢，

-Abraham

推荐答案

您好，

你能不能通过以下帖子，它可以帮助你。

Can you please go through below thread ,It may helps you.

https://github.com/Microsoft/mssql-jdbc/issues/874

https://github.com/Microsoft/mssql-jdbc/issues/874

=============================== ====================================

请点击"标记为"答"如果它解决了你的问题和/或"投票有用"如果有帮助的话这对阅读此主题的其他社区成员有益。

===================================================================
Please click "Mark as Answer" if it solved your issue and/or "Vote as helpful" if it helped. This can be beneficial to other community members reading this thread.

这篇关于pivot on始终加密列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！