RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
SQL-Query Basics
«Prev
Next»
Queries Cursors Views
SQL-Query Basics
Executing Queries
Batch Queries
System Catalogs
Writing Logic Queries
Dynamic SQL Statements
SQL Server Basics
Selecting Data
Data Overview
Retrieving Data Multiple Tables
Multiple Table Retrieval
Alternate Queries Aliases
Construct Union Queries
Additional Keywords Queries
Define Aggregate Queries
Aggregated Data Queries
Describe Write Subqueries
Using Subqueries - Exercise
Selecting Data Conclusion
Advanced Queries
Inserting Transact SQL Data
Updating Transact-SQL Data
Deleting Data
SQL Statement Punctuation
Insert Values from other Table
Update Values from other Table
Different Datatypes
Subquery Statements
Indexing Query Strategies
Full Text Searching
Full Text Searching
Full Text Searching Components
Defining Full Text Indexes
Implement Full Text Search
Full Text Searching
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.