Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Create a Testing Table for Tutorial Exercises
(Continued from previous topic...)
How To Create a Testing Table with Test Data?
If you want to follow the tutorial exercises presented in this collection,
you need to create a testing table and insert some test data, as shown in the following sample script:
CREATE TABLE fyi_links (id INTEGER PRIMARY KEY,
url VARCHAR(80) NOT NULL,
created DATETIME NOT NULL DEFAULT(getdate()))
INSERT INTO fyi_links VALUES (101,
INSERT INTO fyi_links VALUES (102,
INSERT INTO fyi_links (url, id)
VALUES ('sqa.fyicenter.com', 103);
You should keep this table and its data to practice other tutorial exercises presented in this collection.
(Continued on next topic...)
- What Is a SELECT Query Statement?
- How To Create a Testing Table with Test Data?
- How To Select All Columns of All Rows from a Table with a SELECT statement?
- How To Select Some Specific Columns from a Table in a Query?
- How To Select Some Specific Rows from a Table?
- How To Add More Data to the Testing Table?
- How To Sort the Query Output with ORDER BY Clauses?
- Can the Query Output Be Sorted by Multiple Columns?
- How To Sort Query Output in Descending Order?
- How To Count Rows with the COUNT(*) Function?
- Can SELECT Statements Be Used on Views?
- How To Filter Out Duplications in the Returning Rows?
- What Are Group Functions in Query Statements?
- How To Use Group Functions in the SELECT Clause?
- Can Group Functions Be Mixed with Non-group Selection Fields?
- How To Divide Query Output into Multiple Groups with the GROUP BY Clause?
- How To Apply Filtering Criteria at Group Level with The HAVING Clause?
- How To Count Duplicated Values in a Column?
- Can Multiple Columns Be Used in GROUP BY?
- Can Group Functions Be Used in the ORDER BY Clause?