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.
In case youâre curious, hereâs a list of the most densely populated countries and the number of people per sq km (Note: this list excludes countries with exceedingly small land area to begin with, such as city-states Monaco (22,021) or Singapore (6,430)): 1. Bangladesh (985). 2.