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.
Apart then being the second smallest state in Europe (and the world), Monaco is also the most densely populated country in the world. Smallest Countries In Europe: Monaco. 3. San Marino â 61 km 2 (24 mi 2) â The republic of San Marino is an enclave within Italy and has a population of around 30,000 people.ocated within Rome, the smallest state in Europe has a population of just over 800 people. Smallest Countries In Europe: Vatican City, In the heart of Rome. 2. Monaco â 2.02 km 2 (0.78 mi 2) â The Principality of Monaco achieved full independence from France in 1860.