How to view the value parameter of the query below?

Theang Meakkra 0 Reputation points
2023-11-13T00:53:42.77+00:00

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,

Meakkra

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

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 28,041 Reputation points
    2023-11-13T03:16:03.58+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.