Contents

What is Lifelong Learning

Misguided Solution

Report on Educational Technology

Learn SQL Thru Query Analyzer

SQL Test Codes

SQL Review Notes

Java Test Codes

Notes on Learning Java

TCP/IP

C++ CGI Learning Project

Windows NT Overview

Working with Red Hat Linux

Overview of JINI Networking Technology

Remote Access for VPNs

The Author

SQL Test Codes

Query Analyzer is very convenient tool to test and debug your SQL code. It enables quick test table creation and coding of queries and other procedures. It's the best way of learning MS SQL Server's syntax.

Coding and testing SQL commands will give you deeper understanding of how the command works and will give you an opportunity to try different approaches of solving the task at hand.

I have included a few sets of test codes which you can use as a model for creating your own and as a way of practicing your skill at using the SQL language. You can load the test code by copying and pasting into your Query Analyzer code window. Once you understand what the code is doing, then it's time for you to create your own. Use your imagination in coming up with specifications on how you wish the data in your test table be manipulated.   

1. Transactions Test Codes. This set of test codes show creating tables, populating tables, using joins, creating views and procedures, and using transactions.   

2. Compute Test Codes. This set includes examples for using the compute and the compute by commands.

3. Procedures and Variables Test Codes. This set of test codes show creating and populating tables, creating procedures, and designing a called procedure together with the calling procedure for transferring data values using the output option. 

4. Triggers Test Codes. These test codes contain examples of trigger procedures. 

I trust and hope that you'll learn a lot from practice coding afforded by sample test codes. Happy Coding!

Previous Article

Next Article

LEDAC    A Writer At Heart    My Doc Files    Optional

Copyright 2008 Aureo P. Castro Email: [email protected]