On 10 September 2015 at 10:21, Greg Low (罗格雷格博士) <[email protected]> wrote: > This one’s driving me crazy and I thought the brains trust might have an > idea. > > Here’s a value that’s stored in an ntext column in a SQL Server DB: > H4sIAAAAAAAEALVW0W7aMBT9lanvre0wBkNtJEo3DWkFBGGvyDiXYi22M9vpYL/Wh33SfmGGJASatKOS95KH3HvPyTk+tvPn6fe1NLg3Bas5PMIsS0H3GVOZtJGm0lBmuZJfuLFKb99tRCJNzw3cXKytTXsIGbYGQc2V4Ewro1b2iimBZj8SFGDcRbiNom0K8UQrBnGmwaB4qS4OQIS8AakCmYLJEjsDu4dD5dffg1iC/sZjUF+5/F7RdP2zTEAbJWlyB5byxFRc7/1zFQsyjEFavuKM7takYmz/N8ZZJgTV24rqo3+qfeSG8hGMFU7fON2JO/KTeDX09YBXrB3/QgdKWsdWCwzxwjVPY2qhH8euZOocH3xwmHTxAHaRgjTOswXNbVwsaUIlg6CiC7xs61zSZK0k1AX9g8CBtxDBaAaa04T/2m8ZdDTvJcn5FxYHAjXmp9JxxdHymaFyR6bAnCCXpZg/3yhvOZXPzGxEN3vnav57ydMp1y01nNUX2quLkzy6ZxwAgRc3TwLy0o1BvB7gcwNaUgH1PBIv12Au6ZNwGkol4f4fIl3kOkfZ7hm2MOm0OteooVS0F6swcHAPzvuwPxjM70k58bxaDB2t2aE0GI+i6fB2Hg3Ho3K8qa8OcedKn7USYYBJ+xJ3LjFpADh0NQNEqhjvOoQXxl1PaRLd5DaMV0c9IcH44FVzx6lrjS6f1vK359184V9pkluuCgoAAA== > > Somehow, that’s apparently meant to be either a) an XML file, or b) a > GZipped XML file.
echo "H4s...." | base64 -d | gunzip <ns0:RetrieveSuperAccountTransactionHistory xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo"; xmlns:ns11="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberVideoLink"; xmlns:ns8="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberPersonalDetails"; xmlns:ns4="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberAccountIdentification"; xmlns:ns5="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberAccountSummary"; xmlns:ns9="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberSuperInvestmentOptions"; xmlns:ns14="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveSuperAccountTransactionHistory"; xmlns:ns7="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberContactDetails"; xmlns:ns17="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/UpdateAddressDetails"; xmlns:ns16="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/sp_get_pension_account_balance2"; xmlns:ns21="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/UpdatePhoneDetails"; xmlns:ns1="http://schemas.microsoft.com/2003/10/Serialization/"; xmlns:ns19="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/UpdateMemberPassword"; xmlns:ns3="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveAccountSpecialConditions"; xmlns:ns10="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberTaxationDetails"; xmlns:ns6="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveMemberBasicDetails"; xmlns:ns13="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrievePensionAccountTransactionHistory"; xmlns:ns20="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/UpdateMemberPersonalDetails"; xmlns:ns15="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/RetrieveUsernamePassword"; xmlns:ns18="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/UpdateEmailDetails";><ns0:p_MemberNumber>301737</ns0:p_MemberNumber><ns0:p_AccountCategory>ACCUM1</ns0:p_AccountCategory><ns0:p_TransactionCategory>CONTRIBUTION</ns0:p_TransactionCategory><ns0:p_TransactionDateFrom>2015-07-01</ns0:p_TransactionDateFrom><ns0:p_TransactionDateTo>2015-08-07</ns0:p_TransactionDateTo><ns0:p_MaxNumberOfTransaction>100</ns0:p_MaxNumberOfTransaction><ns0:p_AccountNumber>301737</ns0:p_AccountNumber></ns0:RetrieveSuperAccountTransactionHistory> -- Thomas Koster
