| |
<!-- Name = WebClubSQL.html -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<TITLE>WebMaster SQL Search</TITLE>
<!-- Copyright 2000 Alonzo L. Hosford, Jr. -->
<!-- Permission for use in work is granted by not for training or publication -->
</head>
<body>
<!-- Copyright Alonzo L. Hosford, Jr. 1998 - 1999 -->
<form action="WebClubSQL.asp" method=post>
<table align = "center" border = "1" width = "725">
<tr>
<td valign = "top" align = "center" colspan = "2">
<h2>Lon's SQL (Structured Query Language) Builder</h2>
<h4>For NJIT Web Master Students</h4>
</td>
</tr>
<tr>
<td valign = "top">
SQL Statement
</td>
<td>
<textarea cols="80" rows="10" name="SQL">
Select * from WebClubMembers
</textarea>
</td>
</tr>
<tr>
<td align = "center" colspan = "2">
<input type="submit" value="Execute SQL">
<input type="reset">
</td>
</tr>
<tr>
<td Align = "center" valign = "top" colspan = "2">
<br>
<b>Sample SQL Statements</b>
<br><br>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select * from WebClubMembers Order By LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName from WebClubMembers
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName from WebClubMembers Order By LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName, MemberSince from WebClubMembers
Where MemberSince > #1/15/2000#
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName, MemberSince from WebClubMembers
Where MemberSince > #1/15/2000# And MemberSince < #2/15/2000#
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select FirstName & ' ' & LastName as Name from WebClubMembers
Where MemberSince > #1/15/2000# And MemberSince < #2/15/2000#
Order By LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName, MemberSince from WebClubMembers
Where MemberSince Is Null
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname & ', ' & FirstName from WebClubMembers
Order By LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname & ', ' & FirstName As ClubMemberName from WebClubMembers
Order By LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname & ', ' & FirstName As "Club Member Name" from WebClubMembers
Order By LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName, MemberSince from WebClubMembers
Where MemberSince Is Not Null
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName from WebClubMembers Where LastName like 'T%'
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName from WebClubMembers Where LastName like 'Ho%'
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname, FirstName from WebClubMembers Where LastName like 'D%N'
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select Lastname As Last, FirstName As First from WebClubMembers
Order by LastName, FirstName
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select * from Products
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select * from Products Order By Name
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select * from Products Where QuantityOnHand < 10
</code>
</td>
</tr>
<tr>
<td valign = "top" colspan = "2">
<code>
Select * from Products Order By Price Desc
</code>
</td>
</tr>
</table>
</form>
</body>
</html>
|
|