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. England has overtaken the Netherlands and is second only to tiny Malta. Over the next 30 years the gap is expected to widen even more.
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.