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.