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.
List of the 100 most densely populated cities in the United Kingdom, measured in people per square miles. 1  Portsmouth, Hampshire â 15,336. 2  London â 13,870. 3  Leicester, Leicestershire â 11,800. 4  Glasgow, Glasgow â 8,542. 5  Bristol, Bristol â 13,398. 6  Liverpool, Merseyside â 12,790. 7  Stoke-on-Trent, Staffordshire â 11,939.