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.
Egypt is the most populous country in the Arab World and the third-most populous on the African continent. About 95% of the country's 93 million people live along the banks of the Nile and in the Nile Delta, which fans out north of Cairo; and along the Suez Canal. These regions are among the world's most densely populated, containing an average of over 3,820 persons per square mile, as compared to 181 persons per sq. mi. for the country as a whole. Small communities spread throughout the desert