SQL-Query Basics  «Prev  Next»

Logic within SQL-Server Queries - Exercise<

Write logic within your queries

Objective: Practice writing logic within your queries.

Exercise Scoring

This exercise is worth a total of 10 points. You will receive up to 10 points for accurately writing query logic, as described in the instructions.

Instructions

Many times during the course of testing your databases, you need to generate data. Therefore, suppose you need to insert 1000 rows of data. Write query logic to show the structure of how you would accomplish this. The INSERT statement is covered in a later lesson in this module. Therefore, you will not be held accountable for the correctness of the INSERT statement. You can simply write in English words how you would insert data into the table.

Submitting the Exercise

Type or paste your Transact-SQL statement into the text box below, then click Submit to submit your answer to the course and view a results page.