Iterate values on xml nodes SQL Server

I'm trying to extract all the values from each XML node. For example for the <Cash> node, I would like to recover the value (0,1) but I can not get it

CREATE TABLE #TableXML (Col1 INT PRIMARY KEY, Col2 XML) 



INSERT INTO #TableXML 

VALUES (1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)



WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT 

    b.Col1,

    x.XmlCol.value('(ns:Cookie/ns:SmallAmount/text())[2]', 'int') AS SmallAmount,

    x.XmlCol.value('(ns:Cookie/ns:Cash/text())[2]', 'int') AS Cash

FROM

    #TableXML b

CROSS APPLY 

    b.Col2.nodes('CookedUP/Evenement') x(XmlCol);

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

asked Nov 14 '18 at 18:16

Ilyas

658

What are your expected results? Do you want all values of a particular column in the same cell?

– Ryan Wilson
Nov 14 '18 at 18:32

for example , In Nodes Code i want to extract values (A,B) in a column called Code

– Ilyas
Nov 14 '18 at 18:36

Thank you for clarifying.

– Ryan Wilson
Nov 14 '18 at 18:36

add a comment |

I'm trying to extract all the values from each XML node. For example for the <Cash> node, I would like to recover the value (0,1) but I can not get it

CREATE TABLE #TableXML (Col1 INT PRIMARY KEY, Col2 XML) 



INSERT INTO #TableXML 

VALUES (1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)



WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT 

    b.Col1,

    x.XmlCol.value('(ns:Cookie/ns:SmallAmount/text())[2]', 'int') AS SmallAmount,

    x.XmlCol.value('(ns:Cookie/ns:Cash/text())[2]', 'int') AS Cash

FROM

    #TableXML b

CROSS APPLY 

    b.Col2.nodes('CookedUP/Evenement') x(XmlCol);

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

asked Nov 14 '18 at 18:16

Ilyas

658

What are your expected results? Do you want all values of a particular column in the same cell?

– Ryan Wilson
Nov 14 '18 at 18:32

for example , In Nodes Code i want to extract values (A,B) in a column called Code

– Ilyas
Nov 14 '18 at 18:36

Thank you for clarifying.

– Ryan Wilson
Nov 14 '18 at 18:36

add a comment |

I'm trying to extract all the values from each XML node. For example for the <Cash> node, I would like to recover the value (0,1) but I can not get it

CREATE TABLE #TableXML (Col1 INT PRIMARY KEY, Col2 XML) 



INSERT INTO #TableXML 

VALUES (1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)



WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT 

    b.Col1,

    x.XmlCol.value('(ns:Cookie/ns:SmallAmount/text())[2]', 'int') AS SmallAmount,

    x.XmlCol.value('(ns:Cookie/ns:Cash/text())[2]', 'int') AS Cash

FROM

    #TableXML b

CROSS APPLY 

    b.Col2.nodes('CookedUP/Evenement') x(XmlCol);

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

asked Nov 14 '18 at 18:16

Ilyas

658

I'm trying to extract all the values from each XML node. For example for the <Cash> node, I would like to recover the value (0,1) but I can not get it

CREATE TABLE #TableXML (Col1 INT PRIMARY KEY, Col2 XML) 



INSERT INTO #TableXML 

VALUES (1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)



WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT 

    b.Col1,

    x.XmlCol.value('(ns:Cookie/ns:SmallAmount/text())[2]', 'int') AS SmallAmount,

    x.XmlCol.value('(ns:Cookie/ns:Cash/text())[2]', 'int') AS Cash

FROM

    #TableXML b

CROSS APPLY 

    b.Col2.nodes('CookedUP/Evenement') x(XmlCol);

sql-server xml tsql

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

asked Nov 14 '18 at 18:16

Ilyas

658

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

asked Nov 14 '18 at 18:16

Ilyas

658

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

edited Nov 14 '18 at 21:41

marc_s

573k12811071255

asked Nov 14 '18 at 18:16

Ilyas

658

asked Nov 14 '18 at 18:16

Ilyas

658

asked Nov 14 '18 at 18:16

Ilyas

658

What are your expected results? Do you want all values of a particular column in the same cell?

– Ryan Wilson
Nov 14 '18 at 18:32

for example , In Nodes Code i want to extract values (A,B) in a column called Code

– Ilyas
Nov 14 '18 at 18:36

Thank you for clarifying.

– Ryan Wilson
Nov 14 '18 at 18:36

add a comment |

What are your expected results? Do you want all values of a particular column in the same cell?

– Ryan Wilson
Nov 14 '18 at 18:32

for example , In Nodes Code i want to extract values (A,B) in a column called Code

– Ilyas
Nov 14 '18 at 18:36

Thank you for clarifying.

– Ryan Wilson
Nov 14 '18 at 18:36

What are your expected results? Do you want all values of a particular column in the same cell?

– Ryan Wilson
Nov 14 '18 at 18:32

for example , In Nodes Code i want to extract values (A,B) in a column called Code

– Ilyas
Nov 14 '18 at 18:36

Thank you for clarifying.

– Ryan Wilson
Nov 14 '18 at 18:36

add a comment |

1 Answer
1

active

oldest

votes

Small tweak to what you already have and you got it.
The namespaces doesn't come into play until the Cookie node.

I update the example to a table variable, give this a try:

DECLARE @TableXML TABLE(Col1 int primary key, Col2 xml) 

Insert into @TableXML values ( 1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)





;WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT b.Col1

        --Also include the namespaces here with ns: for each "field" you are after contained within Cookie

       ,XmlCol.value('(./ns:SmallAmount)[1]', 'int') AS SmallAmount

       ,XmlCol.value('(./ns:Cash)[1]', 'int') AS Cash

       ,XmlCol.value('(./ns:Code)[1]', 'nvarchar(10)') AS Code

       ,XmlCol.value('(./ns:CashSource)[1]', 'nvarchar(10)') AS CashSource

FROM @TableXML b

CROSS APPLY b.Col2.nodes('/CookedUP/Evenement/ns:Cookie') AS x(XmlCol) --ns, the namespace, only at Cookie node.

edited Nov 14 '18 at 18:48

answered Nov 14 '18 at 18:43

Tim Mylott

8788

thanks @Tim , works perfectly

– Ilyas
Nov 14 '18 at 19:09

@Ilyas glad to help, you're welcome

– Tim Mylott
Nov 14 '18 at 19:16

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53306468%2fiterate-values-on-xml-nodes-sql-server%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Small tweak to what you already have and you got it.
The namespaces doesn't come into play until the Cookie node.

I update the example to a table variable, give this a try:

DECLARE @TableXML TABLE(Col1 int primary key, Col2 xml) 

Insert into @TableXML values ( 1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)





;WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT b.Col1

        --Also include the namespaces here with ns: for each "field" you are after contained within Cookie

       ,XmlCol.value('(./ns:SmallAmount)[1]', 'int') AS SmallAmount

       ,XmlCol.value('(./ns:Cash)[1]', 'int') AS Cash

       ,XmlCol.value('(./ns:Code)[1]', 'nvarchar(10)') AS Code

       ,XmlCol.value('(./ns:CashSource)[1]', 'nvarchar(10)') AS CashSource

FROM @TableXML b

CROSS APPLY b.Col2.nodes('/CookedUP/Evenement/ns:Cookie') AS x(XmlCol) --ns, the namespace, only at Cookie node.

edited Nov 14 '18 at 18:48

answered Nov 14 '18 at 18:43

Tim Mylott

8788

thanks @Tim , works perfectly

– Ilyas
Nov 14 '18 at 19:09

@Ilyas glad to help, you're welcome

– Tim Mylott
Nov 14 '18 at 19:16

add a comment |

Small tweak to what you already have and you got it.
The namespaces doesn't come into play until the Cookie node.

I update the example to a table variable, give this a try:

DECLARE @TableXML TABLE(Col1 int primary key, Col2 xml) 

Insert into @TableXML values ( 1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)





;WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT b.Col1

        --Also include the namespaces here with ns: for each "field" you are after contained within Cookie

       ,XmlCol.value('(./ns:SmallAmount)[1]', 'int') AS SmallAmount

       ,XmlCol.value('(./ns:Cash)[1]', 'int') AS Cash

       ,XmlCol.value('(./ns:Code)[1]', 'nvarchar(10)') AS Code

       ,XmlCol.value('(./ns:CashSource)[1]', 'nvarchar(10)') AS CashSource

FROM @TableXML b

CROSS APPLY b.Col2.nodes('/CookedUP/Evenement/ns:Cookie') AS x(XmlCol) --ns, the namespace, only at Cookie node.

edited Nov 14 '18 at 18:48

answered Nov 14 '18 at 18:43

Tim Mylott

8788

thanks @Tim , works perfectly

– Ilyas
Nov 14 '18 at 19:09

@Ilyas glad to help, you're welcome

– Tim Mylott
Nov 14 '18 at 19:16

add a comment |

Small tweak to what you already have and you got it.
The namespaces doesn't come into play until the Cookie node.

I update the example to a table variable, give this a try:

DECLARE @TableXML TABLE(Col1 int primary key, Col2 xml) 

Insert into @TableXML values ( 1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)





;WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT b.Col1

        --Also include the namespaces here with ns: for each "field" you are after contained within Cookie

       ,XmlCol.value('(./ns:SmallAmount)[1]', 'int') AS SmallAmount

       ,XmlCol.value('(./ns:Cash)[1]', 'int') AS Cash

       ,XmlCol.value('(./ns:Code)[1]', 'nvarchar(10)') AS Code

       ,XmlCol.value('(./ns:CashSource)[1]', 'nvarchar(10)') AS CashSource

FROM @TableXML b

CROSS APPLY b.Col2.nodes('/CookedUP/Evenement/ns:Cookie') AS x(XmlCol) --ns, the namespace, only at Cookie node.

edited Nov 14 '18 at 18:48

answered Nov 14 '18 at 18:43

Tim Mylott

8788

Small tweak to what you already have and you got it.
The namespaces doesn't come into play until the Cookie node.

I update the example to a table variable, give this a try:

DECLARE @TableXML TABLE(Col1 int primary key, Col2 xml) 

Insert into @TableXML values ( 1,

'<CookedUP>

  <Evenement Calcul="16">

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>0</Cash>

      <CashInterest>0</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>A</Code>

      <SmallAmount>0</SmallAmount>

      <SmallAmountType>Undefined</SmallAmountType>

    </Cookie>

    <Cookie xmlns="http://services.ariel.morneausobeco.com/2007/02" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

      <AlternateOptionTypeCodes />

      <Cash>1</Cash>

      <CashInterest>2</CashInterest>

      <CashSource>Undefined</CashSource>

      <Code>B</Code>

      <SmallAmount>1</SmallAmount>

      <SmallAmountType>1</SmallAmountType>

    </Cookie>

  </Evenement>

</CookedUP> '

)





;WITH XMLNAMESPACES ('http://services.ariel.morneausobeco.com/2007/02' AS ns)

SELECT b.Col1

        --Also include the namespaces here with ns: for each "field" you are after contained within Cookie

       ,XmlCol.value('(./ns:SmallAmount)[1]', 'int') AS SmallAmount

       ,XmlCol.value('(./ns:Cash)[1]', 'int') AS Cash

       ,XmlCol.value('(./ns:Code)[1]', 'nvarchar(10)') AS Code

       ,XmlCol.value('(./ns:CashSource)[1]', 'nvarchar(10)') AS CashSource

FROM @TableXML b

CROSS APPLY b.Col2.nodes('/CookedUP/Evenement/ns:Cookie') AS x(XmlCol) --ns, the namespace, only at Cookie node.

edited Nov 14 '18 at 18:48

answered Nov 14 '18 at 18:43

Tim Mylott

8788

edited Nov 14 '18 at 18:48

answered Nov 14 '18 at 18:43

Tim Mylott

8788

answered Nov 14 '18 at 18:43

Tim Mylott

8788

answered Nov 14 '18 at 18:43

Tim Mylott

8788

thanks @Tim , works perfectly

– Ilyas
Nov 14 '18 at 19:09

@Ilyas glad to help, you're welcome

– Tim Mylott
Nov 14 '18 at 19:16

add a comment |

thanks @Tim , works perfectly

– Ilyas
Nov 14 '18 at 19:09

@Ilyas glad to help, you're welcome

– Tim Mylott
Nov 14 '18 at 19:16

thanks @Tim , works perfectly

– Ilyas
Nov 14 '18 at 19:09

@Ilyas glad to help, you're welcome

– Tim Mylott
Nov 14 '18 at 19:16

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

OzQP93B3X7Jaz7W37CrJz1pk38uiXzalJ3K,64M2dXJgfeeN62H SzvKHH cfxurXDK3FbwuNLLi2GT,8V73Vunq2ZTdz,LgOFf,uTKB

搜尋此網誌

Wsrtjtyk