1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in SQL Server

Exercise

Commenting - how many Kiwis in the NBA?

You and a friend would like to know how many New Zealanders (affectionately known as Kiwis) play in the NBA. Your friend attempts to write a query, but it is not very well formatted and contains several errors. You re-write the query, but you want to keep his original for comparison and future reference.

This exercise requires you to create line comments and comment out blocks of code

Instructions

100 XP
  • Add the line comment First attempt, contains errors and inconsistent formatting on line 2.
  • Block comment out your friend's query on lines 3 and 11.
  • Add the line comment Second attempt - errors corrected and formatting fixed on line 14.
  • Remove the block comment syntax from your query on lines 15 and 23.