string data = "India, officially the Republic of India (Bharat Ganrajya)[c], is a country in South Asia. It is the seventh-largest country by area, the second-most populous country with over 1.2 billion people, and the most populous democracy in the world ";

return data.Split(new string[] { "populous" }, StringSplitOptions.None);

Continue reading

xml1.xml
----------------------------------------


<?xml version="1.0" encoding="utf-8"?>
<AllNodes>
   <NodeA>
      <NodeB>test1</NodeB>
      <NodeB>test2</NodeB>
   </NodeA>
</AllNodes>

xml2.xml
-------------------



<?xml version="1.0" encoding="utf-8"?>
<AllNodes>
   <NodeA>
      <NodeB>test6</NodeB>
      <NodeB>test7</NodeB>
   </NodeA>
   <NodeA>
      <NodeB>test99</NodeB>
      <NodeB>test23</NodeB>
   </NodeA>
</AllNodes>



using LINQ to XML



var xml1 = XDocument.Load("xml1.xml");
var xml2 = XDocument.Load("xml2.xml");

//Combine and remove duplicates
var combinedUnique = xml1.Descendants("AllNodes")
                          .Union(xml2.Descendants("AllNodes"));

//Combine and keep duplicates
var combinedWithDups = xml1.Descendants("AllNodes")
                           .Concat(xml2.Descendants("AllNodes"));

Continue reading

 List all triggers(including database level) in the database - QUICK SYNTAX

SELECT *  FROM [AdventureWorks2008].[sys].[triggers]

Continue reading