How to view the value parameter of the query below?

Theang Meakkra 0 Reputation points

Dear Everyone,

I would like to ask another question related to output of query, In SQL server we got the outcome of the query below from the app level.

UPDATE [CustomerAccount] SET [AccountTypeId] = @p0, [ActiveBit] = @p1, [CrDt] = @p2, [CustomerAccountAaliasName] = @p3, [CustomerAccountCbsName] = @p4, [CustomerAccountCurrency] = @p5, [CustomerAccountDefault] = @p6, [CustomerAccountHidden] = @p7, [CustomerAccountJoinAccType] = @p8, [CustomerAccountNotificationBit] = @p9, [CustomerAccountNumber] = @p10, [CustomerAccountRestrictCredit] = @p11, [CustomerAccountRestrictDebit] = @p12, [CustomerAccountStatus] = @p13, [CustomerId] = @p14, [UpDt] = @p15 WHERE [CustomerAccountId] = @p16 0x00000000000000000000000000000001 6 26884090 2 NULL NULL SITMBAPP01 7076 Core Microsoft SqlClient Data Provider MB_APP 91 NULL 2023-11-07 14:52:49.597 NULL NULL NULL

Do we have the way or query to view those parameter value (@p0, @p1, @p2, @p3...)? We would like to know what is the exact value that have been updated from what value to what value.

It is my pleasure if everyone can help, thank you in advance.

Best Regards,


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,614 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CosmogHong-MSFT 17,231 Reputation points Microsoft Vendor

    Hi @Theang Meakkra

    Do we have the way or query to view those parameter value (@p0, @p1, @p2, @p3...)?

    Try Print @p0; Print @p1; Print @p3; Or Select @p0, @p1, @p2, @p3

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments