Jump to content

JSON AUTO - Aplicar um alias para a string de saída

Recommended Posts

Ufa...encontrei a solução... usando subconsulta.


      SELECT SalesOrderNumber AS 'Order.Number',
             OrderDate AS 'Order.Date'
        FROM Sales.SalesOrderHeader
         FOR JSON PATH
) AS SalesOrder


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.