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.
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.