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. England has overtaken the Netherlands and is second only to tiny Malta. Over the next 30 years the gap is expected to widen even more.
The most densely populated provinces are in the east: Jiangsu (767 persons per square kilometer), Shandong (611 persons per square kilometer), Guangdong (580 persons per square kilometer), and Henan (568 persons per square kilometer).his articles lists of the first-level administrative divisions of People's Republic of China (P.R.C.), including all provinces, autonomous regions, special administrative regions, and municipalities, in order of their population density at the census of 2010.