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); [.....]
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")
[.....]
List all triggers(including database level) in the database - QUICK SYNTAX SELECT * FROM [AdventureWorks2008].[sys].[triggers] [.....]
