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.
1 The most densely populated sovereign nation is Monaco, with a population density of 16,754 people/km 2. 2  Antarctica is a continent of 14,400,000 km 2 in area with territorial claims from multiple countries that are not included elsewhere in the above table.