Queries Cursors Views
Writing Logic Queries
Dynamic SQL Statements
Retrieving Data Multiple Tables
Multiple Table Retrieval
Alternate Queries Aliases
Inserting Data Transact SQL
SQL Statement Punctuation
Inserting Values from another Table
Updating Values from differentr Table
Indexing Query Strategies
Full Text Searching
Defining Full Text Indexes
Implement Full Text Search
Logic within Queries - Exercise<
Write logic within your queries
Practice writing logic within your queries.
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.
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
to submit your answer to the course and view a results page.