In order to generate such a query dynamically, we can look to sys.columns to derive the column names. Let's say we know the table name and the key column(s), and a pattern the column name should match, then we can pull all of the other columns and build a comma-separated list. In this case, it would look like this:
This worryingly crowded isle: England is officially Europe's most densely packed major country. 1  England has overtaken the Netherlands and is second only to tiny Malta. 2  Over the next 30 years the gap is expected to widen even more. 3  Figures show the huge impact of Labourâs open-door immigration policy.
Surprisingly, none of China's cities make the list of the top 30 most densely populated cities in the world, most of which are in India, the Philippines, France and other countries. Macau, however, is the 36th most densely populated city with a density of 18,568 people per square kilometer (48,092 per square mile).he density figures change dramatically when you look at the largest urban areas, however. Shanghai, the largest city in the country and the world, has a population density of 3,700 people per square kilometer, or 9,700 people per square mile.