How to count distinct and unique values in Excel

=COUNTIF(A2:A23|A2:A23)
=SUM(IF(COUNTIF(A2:A23|A2:A23)=1|1|0))

c# node.selectnodes add attribute

   Item objItem = _inn.newItem("Identity", "get");
            Item logicItm = objItem.newOR();

            logicItm.setProperty("name", "%Admin%");
            logicItm.setProperty("name", "%Author%");

            Item iChildren = objItem.getLogicalChildren();
            for (int i = 0; i < iChildren.getItemCount(); i++)
            {
                Item iChild = iChildren.getItemByIndex(i);
   
                XmlDocument objXDoc = new XmlDocument();
                XmlAttribute objNewAtt = objXDoc.CreateAttribute("condition");
                objNewAtt.Value = "like";

                XmlNodeList allNames = iChild.node.SelectNodes("name");
                foreach (XmlNode eachName in allNames)
                {
                    eachName.Attributes.SetNamedItem(objNewAtt);
                }

            }
            Item retItm = objItem.apply();

How can I get column names from a table in SQL Server?

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.yourTableName')


or

  SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
     TABLE_NAME  ='MyTable'
      AND
      TABLE_CATALOG='MyDBName'

CMD File merge

for /R %f in (*.xml) do type "%f" >> Output.xml