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.
This is a listing of the 24 most populous countries in the world (those having a population over fifty million). Data are estimates for these most populous countries from mid-2010. China - 1,341,335,000. India - 1,224,614,000. United States - 310,384,000. Indonesia - 239,781,000. Brazil - 194,946,000.