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.
Key Areas for Heavy Population Density. The most densely populated parts of the US are found in major metropolitan areas around the states of New York, New Jersey, California, and Connecticut, among others. Such areas boast levels of density above 500 or even topping 1,000 people per square kilometer, making these areas the most crowded in the country.