Professional Visual Basic 6 : A Programmer's Resource

by Alban, Jerry; Ferracchiati, Fabio Claudio; Livingstone-Perez, Steven; Payet, Ryan; Steinle, Larry; Tegels, Kent

• ISBN13: 9781861008183
• ISBN10: 186100818X
• Edition: CD
• Format: Trade Paper
• Copyright: 2003-01-07
• Publisher: Springer-Verlag New York Inc

Table of Contents

Foreword	1	(1)
Who Is This Book For?	2	(1)
What Does This Book Cover?	2	(2)
What Do I Need To Use This Book?	4	(1)
Conventions	4	(1)
Customer Support	5	(4)
How to Download Sample Code for this Book	5	(1)
Errata	6	(1)
E-mail Support	6	(1)
p2p.wrox.com	7	(1)
Why This System Offers the Best Support	7	(2)
``Classic'' Visual Basic in the .NET World	9	(14)
VB -- A Product of its Environment?	11	(5)
Access	16	(1)
SQL Server	17	(1)
ASP	17	(1)
Simple Object Access Protocol -- SOAP	18	(1)
What Else is Important to Learn Now?	19	(1)
Summary	20	(3)
Visual Basic Designs	23	(22)
Development Methodologies	24	(2)
A Structured Formal Methodology	24	(1)
Gathering Phase	24	(1)
Suggesting Phase	24	(1)
Developing Phase	25	(1)
Implementing Phase	25	(1)
Maintaining/Evolving Phase	25	(1)
The Casual Methodology	25	(1)
Architecture Considerations	26	(8)
``Winging It''	26	(1)
Application Architectures	27	(1)
The Three-Tier Model	27	(1)
Logical vs. Physical	28	(1)
Single-Tier Physical Model	28	(3)
Two-Tier Physical Model	31	(1)
Three-Tier Physical Model	31	(1)
N-Tier Physical Model	32	(1)
Microsoft Windows DNA	32	(1)
Integration Considerations	32	(1)
Component Object Model (COM+)	32	(1)
Distributed Component Object Model (DCOM)	33	(1)
XML	33	(1)
Web Services	34	(1)
Design Patterns in Visual Basic 6	34	(8)
What is a Design Pattern?	34	(1)
Design Pattern Origins	35	(1)
Benefits of Design Patterns	35	(1)
Applying Design Patterns to Visual Basic	35	(1)
The Singleton Design Pattern	35	(1)
The Repository Design Pattern	36	(3)
The Adapter Design Pattern	39	(2)
The Abstract Factory Design Pattern	41	(1)
Summary	42	(3)
The Basics of ADO	45	(50)
A Quick History of ADO	45	(1)
The ADO Object Model	46	(3)
Object Hierarchy	47	(1)
Setting a Reference to ADO	48	(1)
Connecting to a Database	49	(6)
Creating a Connection Object	49	(1)
Setting the Connection String	50	(1)
OLE DB Provider for ODBC Drivers	51	(2)
Other OLE DB Providers	53	(1)
Opening the Connection	54	(1)
Closing the Connection	54	(1)
Querying the Database	55	(11)
Creating a Command Object	55	(1)
Building the Command Text	56	(1)
Executing the Command	57	(1)
The Execute Method's Optional Arguments	57	(1)
An Example	58	(1)
Other Command Object Functionality	58	(1)
Executing a Command Without a Command Object	58	(1)
Using a Connection Object	59	(1)
Using a Recordset Object	59	(2)
Parameters	61	(1)
Creating a Parameter Object	61	(2)
The Parameters Collection	63	(1)
Passing Parameters into a Stored Procedure	64	(2)
Viewing and Editing Records	66	(18)
Navigating through the Recordset	66	(1)
Bookmarks	67	(1)
Moving by More than One Record	68	(1)
Recordset Pages	69	(1)
Locating Records in the Recordset	69	(1)
Finding Specific Records	70	(1)
Filtering the Recordset	71	(1)
Retrieving Rows into an Array	72	(1)
Sorting the Recordset	73	(1)
Modifying the Data	73	(1)
Editing Records	73	(1)
Adding Records	74	(1)
Deleting Records	75	(1)
Refreshing the Recordset	76	(1)
Updating the Database	77	(1)
Cursor and Lock Types	78	(1)
Cursor Types	78	(1)
Cursor Location	79	(1)
Lock Types	80	(1)
Working with Fields	80	(1)
The Fields Collection	80	(2)
The Field Object	82	(1)
Disconnected and Persisted Recordsets	83	(1)
ADO Events	84	(5)
Accessing ADO Events	84	(1)
Connection Object Events	84	(1)
The WillConnect Event	85	(1)
The ConnectComplete Event	86	(1)
The Disconnect Event	87	(1)
Recordset Object Events	87	(1)
The MoveComplete Event	88	(1)
The RecordChangeComplete Event	88	(1)
Error Handling	89	(3)
The Errors Collection	89	(1)
The Error Object	90	(2)
Binding to VB Controls with ADO	92	(1)
Summary	93	(2)
Working with the ADO Data Control	95	(32)
Application Walk-Through	95	(1)
Building the Database	96	(5)
Building the Front-End Application	101	(21)
The ADO Data Control	101	(1)
Building the Connection String	102	(3)
Setting the RecordSource Property	105	(1)
Setting the Other Properties	106	(1)
Building a User Interface	106	(3)
What's Going On	109	(1)
The Masked Edit Control	110	(1)
Creating a Navigation Bar	111	(1)
Navigating the Recordset	112	(2)
Updating the Status Label	114	(1)
Further Enhancements	114	(2)
Adding New Records	116	(1)
Deleting Records	117	(1)
Updating Records	117	(1)
Restoring Records	118	(1)
Finding Records	118	(3)
Testing the Search Mechanism	121	(1)
Other Databound Controls	122	(3)
The Label	122	(1)
The Checkbox	122	(1)
The Picture and Image Controls	122	(1)
DataGrid Control	122	(1)
The Hierarchical FlexGrid Control	123	(1)
The DataList and DataCombo Controls	124	(1)
The OLE Container Control	124	(1)
The Rich Textbox Control	124	(1)
The MS Chart Control	125	(1)
The Data Repeater Control	125	(1)
Summary	125	(2)
Views, Stored Procedures, and Triggers	127	(24)
Looking at Views	128	(5)
Views in the Northwind Database	129	(1)
Creating a New View with SQL	130	(1)
Creating a New View Graphically	131	(1)
Modifying Data Using a View	132	(1)
Stored Procedures	133	(12)
Stored Procedures in the Northwind Database	134	(1)
Creating Stored Procedures Using SQL	135	(1)
Executing Stored Procedures from Visual Basic	136	(5)
Output Parameters	141	(2)
System-Level Stored Procedures	143	(2)
Triggers	145	(4)
A Note on the Mode of Operation of Triggers	146	(1)
Creating Triggers	147	(1)
Trigger Happy	148	(1)
Summary	149	(2)
Data Validation, Transactions, and Error Trapping	151	(26)
Data Validation	152	(11)
Data Validation on the Server	152	(1)
Exploring Constraints in SQL Server	153	(6)
Exploring Constraints in Microsoft Access	159	(1)
Adding Validation Constraints with SQL	159	(2)
Data Validation at the Application Level	161	(2)
What Are Transactions?	163	(7)
BeginTrans, CommitTrans and RollBackTrans	165	(5)
ADO and OLE DB Provider Errors	170	(5)
Summary	175	(2)
Advanced ADO	177	(28)
The ADO Disconnected Recordset	178	(5)
Advanced Features of Disconnected Recordsets	180	(1)
Sorting	180	(1)
Filtering	181	(1)
Finding a Record	182	(1)
Remote Data Service	183	(9)
RDS Security Issues	186	(6)
Recordset Persistence	192	(5)
Saving a Recordset	193	(2)
Persisting a Recordset to a Stream Object	195	(1)
XML versus RDS	196	(1)
ADO and XML	197	(6)
SQL Server 2000 and XML	197	(1)
The FOR XML Clause	198	(1)
The RAW Attribute	198	(1)
The AUTO Attribute	198	(1)
The EXPLICIT Attribute	199	(1)
XSD Mapping Schema	200	(1)
Executing XPath Queries with ADO Command	201	(2)
Summary	203	(2)
COM+	205	(44)
What is COM?	206	(2)
The COM Library?	206	(1)
Advantages of COM	207	(1)
Objects & Classes	208	(1)
Objects	208	(1)
Classes	208	(1)
A Simple Illustration	209	(1)
COM Components	209	(8)
Client versus Server	211	(1)
Processes, Threads, and Apartments	212	(1)
Processes	212	(1)
Threads	212	(1)
Apartments	213	(1)
Out-of-process Servers	213	(1)
In-process Servers	214	(1)
Marshalling	215	(1)
Threading Models	215	(2)
Interfaces -- COM's Binary Standard	217	(3)
COM's Contract	218	(1)
Version Control	218	(1)
IDL/MIDL	218	(1)
IUnknown	219	(1)
GUIDs and the Windows Registry	220	(4)
System Registry	220	(1)
Building our own COM Component	221	(3)
COM+ Services	224	(4)
Automatic Transactions	225	(1)
Method-level Role-based Security	225	(1)
Synchronization	225	(1)
Resource Dispenser and Notification Services	226	(1)
Improved Object Instantiation	226	(1)
Object Pooling	226	(1)
Queued Components	226	(1)
COM+ Events	227	(1)
COM+ Catalog	228	(1)
COM+ Applications	228	(8)
Security	230	(2)
Considerations	232	(1)
Roles	232	(1)
Identity	233	(1)
Activation	233	(1)
Queuing	234	(1)
Component Activation	235	(1)
COM+ Object Communication	236	(1)
COM+ Components, Interfaces, and Methods	236	(6)
Transactions	236	(1)
Security	237	(2)
Activation	239	(2)
Concurrency	241	(1)
Required	242	(1)
Requires New	242	(1)
COM+ Context	242	(3)
Context Interfaces	242	(1)
IObjectContext	243	(1)
IObjectContextInfo	243	(1)
IContextState	243	(1)
ISecurityCallContext	244	(1)
IObjectControl	244	(1)
Summary	245	(4)
Component Development	249	(48)
Introducing Business Objects	249	(2)
Business Logic	250	(1)
Types of Business Logic	250	(1)
UI Logic versus Business Logic	250	(1)
Building Components in Visual Basic	251	(1)
Creating a COM+ Component in VB	252	(1)
The Contacts Sample	252	(7)
The Contact Object	253	(1)
The ContactList Object	254	(1)
The Database	254	(1)
Design Issues	255	(1)
Designing in Layers	255	(3)
Multi-Use Objects	258	(1)
The Business Objects	259	(22)
Unattended Execution	260	(1)
The ContactMain Module	261	(1)
The ContactList Class	262	(1)
The Fetch Method	262	(1)
The GetContacts Method	263	(1)
The Contact Class	264	(1)
Declarations	264	(1)
Basic Properties	265	(3)
The Phone and EMail Properties	268	(2)
Retrieving Data	270	(3)
Adding and Updating Data	273	(4)
Deleting Data	277	(1)
Building the Component Server	277	(1)
Compiling a COM+ Object Under VB	277	(1)
Compatibility Issues	278	(1)
The Threading Model	279	(1)
Base Address	280	(1)
Things to Watch For	281	(7)
Object and Component Usability	281	(3)
Performance/Scalability	284	(2)
Maintainability	286	(2)
Designing for COM+ Services	288	(5)
Supporting Transactions	288	(1)
Coding: Properties, Objects, Parameters, and More	289	(1)
Just-In-Time (JIT) Activation	290	(1)
Resource Friendly	290	(1)
Leaving a Trace	290	(2)
Hooking into JIT	292	(1)
Summary	293	(4)
Transactions	297	(36)
Basics of Transactions	297	(3)
Requirements for a Transactional System	298	(1)
Why Do We Need Transactions?	298	(2)
Transaction Processing Systems	300	(4)
Resource Managers	301	(1)
Compensating Resource Managers	302	(1)
Transaction Managers	303	(1)
The Distributed Transaction Coordinator	303	(1)
Two-Phase Commit Protocol	303	(1)
The Application's Role	304	(1)
Transactional Support in COM+	304	(13)
Root and Interior Objects	305	(1)
The Transactional Support Property	305	(2)
Object Context	307	(1)
The IObjectContext Interface	307	(1)
Casting Your Vote	308	(3)
Concurrency	311	(5)
Just-In-Time Activation	316	(1)
Building Transactional Applications in VB 6	317	(14)
Transactional Support for VB 6 Classes	317	(2)
Creating Interior COM+ Objects in VB	319	(2)
The Compensating Resource Manager	321	(1)
CRM Worker	322	(4)
CRM Compensator	326	(4)
Configuring and Using the FileSystemCRM	330	(1)
Summary	331	(2)
COM+ Distributed and Queued Components	333	(46)
Distributed Processing with COM+	333	(2)
Marshalling	334	(1)
Security and Authentication	334	(1)
Resource Collection	334	(1)
Application Issues	335	(1)
A Julian Dates Component	335	(11)
Implementation	338	(1)
Deploying Components with COM+	338	(1)
Configuring Our COM+ Application	339	(2)
Packaging a Component for Export	341	(1)
Configuring the Remote Client	342	(1)
Implications for Real World Applications	342	(1)
Stateful Components and Network Round Trips	343	(1)
Proxies and Stubs	343	(1)
Platform Incompatibilities	343	(1)
SOAP and COM+	344	(1)
COM Internet Services	345	(1)
Microsoft Message Queue	346	(20)
MSMQ Servers	347	(1)
MSMQ Clients	347	(1)
The Nature of MSMQ Queues	348	(1)
Outgoing Queues	349	(1)
System Queues	349	(1)
Public Queues	349	(1)
Private Queues	349	(1)
MSMQ Messages	349	(2)
The MSMQ Object Model	351	(1)
MSMQApplication	351	(1)
MSMQQueueInfo	352	(1)
MSMQQueue	353	(1)
MSMQMessage	354	(2)
MSMQQuery	356	(1)
MSMQQueueInfos	356	(1)
MSMQEvent	356	(1)
MSMQTransaction	357	(1)
MSMQCoordinatedTransactionDispenser	357	(1)
MSMQTransactionDispenser	358	(1)
An MSMQ Application	358	(1)
API to Queue	359	(1)
Request Processor	360	(2)
Client	362	(3)
Other Possibilities	365	(1)
MSMQ Queued COM+ Components	365	(1)
COM+ Queued Components	366	(6)
Queued Components Architecture	367	(1)
QC Sample Solution	368	(4)
Events and Callbacks	372	(4)
How Do Events and Callbacks Work?	372	(1)
ActiveX Data Objects	372	(4)
Summary	376	(3)
VBScript and ASP	379	(36)
VB Lite	379	(3)
Windows Scripting Host	380	(1)
The Log Mover	381	(1)
Introducing Active Server Pages	382	(4)
ASP Basics	382	(1)
ASP Tags	383	(1)
<SCRIPT> Blocks	383	(1)
The Default Scripting Language	383	(1)
Mixing HTML and ASP	384	(1)
Commenting Your ASP Code	385	(1)
The Active Server Pages Object Model	386	(17)
Collections	387	(1)
Iterating the Contents Collection	387	(1)
Removing an Item from the Contents Collection	388	(1)
The Request Object	388	(1)
The Request Object's Collections	389	(3)
Request Object Properties and Methods	392	(1)
The Response Object	393	(1)
The Response Object's Collections	393	(1)
The Response Object's Methods	394	(2)
The Response Object's Properties	396	(1)
The Application and Session Objects	397	(1)
Scope Springs Eternal	397	(1)
The global.asa File	397	(1)
The Application Object	398	(1)
Collections	398	(1)
Methods	398	(1)
Events	398	(1)
The Session Object	399	(1)
Collections	399	(1)
Properties	399	(1)
Methods	400	(1)
Events	400	(1)
The Server Object	401	(1)
Properties	401	(1)
Methods	401	(2)
The ObjectContext Object	403	(1)
SetAbort	403	(1)
SetComplete	403	(1)
Using Active Server Pages Effectively	403	(9)
Designing the Site	403	(2)
Creating the global.asa File	405	(1)
Creating our Main Page	405	(3)
The ASP/VBScript Section	408	(3)
The HTML Section	411	(1)
Summary	412	(3)
Essential XML	415	(38)
XML as a Second Language	416	(7)
Putting XML in Perspective	419	(1)
Well-Formed XML	419	(1)
Valid XML	420	(1)
DTDs	420	(1)
XML Schema	421	(2)
Related Standards	423	(1)
Manipulating XML Data	423	(2)
A Tree Grows in XML	424	(1)
Extensible Style Language (XSL)	425	(5)
XPath	426	(1)
Transforming XML for Display Using XSL	426	(4)
Client-side XML	430	(11)
Generating XML Using Visual Basic 6	430	(1)
Using the ADO Save Method to Save a Recordset as XML	430	(2)
Saving a Recordset as XML Using Custom Code	432	(6)
Saving a Recordset as XML Using The DOM	438	(3)
Server-Side XML	441	(4)
Generating HTML from XML Server-Side	441	(4)
Uploading XML to the Server	445	(6)
Using the ServerXMLHTTP Object	445	(3)
Receiving an XML File on the Server	448	(1)
Receiving XML Using an ASP Script	448	(1)
Receiving XML Using a Visual Basic IIS Application	448	(2)
Running the Code	450	(1)
Summary	451	(2)
SOAP and XML Web Services	453	(34)
XML Web Services	454	(1)
Founding Principles	454	(1)
Web Services Directories	455	(1)
Web Service Discovery	455	(1)
Web Service Description	456	(1)
Web Service Wire Format	456	(1)
Introduction to SOAP	456	(1)
The Microsoft SOAP Toolkit	457	(1)
Component Objects	457	(1)
COM and the SOAP Toolkit	458	(1)
SOAP Toolkit Basics	458	(11)
Setting Up IIS	459	(3)
A Simple Web Service	462	(1)
Generating WSDL Files	463	(2)
A Simple Consumer	465	(4)
Consuming a .NET Web Service with SoapClient30	469	(1)
Handling Errors	469	(1)
Errors with SoapClient30	470	(1)
Handling User-Defined Data Types	470	(14)
A Little Help From DataSet	470	(2)
A .NET Web Service	472	(2)
XML DataSet to ADODB.Recordset	474	(6)
Testing the Conversion	480	(4)
Limitations of the Conversion Routine	484	(1)
Summary	484	(3)
Looking Forward to .NET	487	(20)
What is .NET?	488	(1)
The Implications for Visual Basic	488	(1)
Why Move From VB 6 to .NET?	489	(1)
Architecting VB 6 Applications with a View to .NET	489	(5)
N-Tier, But Different	490	(1)
Web Services	491	(1)
Remoting	491	(1)
VB 6 Programming Recommendations	492	(1)
Explicitly Declare your Variables	492	(1)
Take Care with Parameters	492	(1)
Use Early Binding	493	(1)
Application Upgrade	493	(1)
So, What's Changed?	494	(6)
New Features	494	(1)
Inheritance	494	(1)
Overloading	494	(1)
Parameterized Constructors	495	(1)
Declaration and Initialization	495	(1)
Structured Exception Handling	496	(1)
Free Threading	496	(1)
Short Circuiting	496	(1)
Shared Members	496	(1)
Strict Typing	497	(1)
Garbage Collection	497	(1)
Feature Changes	497	(1)
Language Changes	497	(3)
VB.NET Classes	500	(1)
ADO moves to ADO.NET	500	(1)
A New IDE	500	(5)
Summary	505	(2)
Appendix A: Visual Basic Tips and Tricks	507	(20)
The Win32 API	507	(1)
List boxes and Combo boxes	507	(2)
Intercepting Windows Messages -- Subclassing	509	(1)
INI Files	510	(2)
ADO	512	(1)
Connection Strings	512	(1)
Stored Procedures	512	(1)
Identity Fields	513	(1)
Always Close Recordsets and Connections	514	(1)
Disconnected Recordsets and Firehose Cursors	515	(1)
GetRows	515	(1)
SQL Syntax	515	(1)
Collection Classes	516	(1)
Forms	516	(1)
Center a Form on the Screen Programmatically	516	(1)
Memory Management	516	(1)
Catching Errors on Form_Load	517	(1)
Looping Through a Form's Controls	518	(1)
Looping Through the Forms Collection	519	(1)
ZOrder Method	519	(1)
Reading and Writing Files	519	(1)
Working with Objects	520	(1)
With...End With Block	520	(1)
Is Operator	520	(1)
New Keyword	521	(1)
Events	521	(1)
ByVal and ByRef	522	(1)
General Syntax	523	(1)
Nulls	523	(1)
Optional Parameters	523	(1)
ParamArrays	523	(1)
Option Compare Text	524	(1)
Keyboard Shortcuts	524	(3)
Appendix B: Visual Studio Installer	527	(24)
Microsoft Windows Installer	527	(2)
Installing Visual Studio Installer	529	(1)
Installing the Installer Engine	529	(1)
Creating an Installer Package	529	(8)
Creating a Visual Studio Installer Project	530	(1)
The Visual Studio IDE	531	(1)
Configuring the Visual Studio Installer Project	532	(1)
Build Options	533	(1)
Installation Folder	534	(1)
Product Information	534	(1)
Support	534	(1)
Summary	535	(1)
Merge Module Search Path	535	(1)
Launch Condition	535	(1)
Organizing Component Properties	535	(1)
Modifying the File System	536	(1)
Initializing the Registry	536	(1)
Guiding the User through the Install Process	537	(1)
Compiling the Installer Project	537	(1)
Deploying COM Components	537	(5)
Registering the Component	538	(1)
Self-registration	538	(1)
Association	539	(2)
Isolation	541	(1)
Creating a Merge Module Package	542	(2)
Creating a Visual Studio Merge Module Project	542	(1)
Deploying and Consuming a Merge Module Package	543	(1)
Isolating a Merge Module Package	544	(1)
Testing and Deploying Installer Packages	544	(1)
Testing Installer Packages and Merge Modules	545	(1)
Deploying Installer Packages	545	(1)
Advanced Packaging Concepts	545	(3)
Orca Editor	545	(1)
Creating a Package with a Custom Application Path	546	(1)
Creating Per-Machine Install Packages	547	(1)
Conclusion	548	(3)
Appendix C: Deployment Techniques -- Wise Installation System	551	(18)
Installation Expert	551	(10)
Project Definition Group	552	(1)
Product Details	552	(1)
General Information	553	(1)
Add Remove Programs	553	(1)
Components	553	(1)
Installation Details Group	554	(1)
Files	554	(1)
Shortcuts	555	(1)
Registry	555	(1)
INI Files	556	(1)
File Associations	556	(1)
Fonts	556	(1)
Services	556	(1)
Runtimes	556	(1)
BDE Runtime	557	(1)
ODBC	557	(1)
Target System Group	557	(1)
System Requirements	557	(1)
System Search	557	(1)
Installation Log	557	(1)
Uninstall Support	557	(1)
User Interface Group	557	(1)
Dialogs	557	(2)
Screen	559	(1)
Billboards	559	(1)
Progress Bar	559	(1)
Build Options	559	(1)
Build Settings	559	(1)
Compiler Variables	559	(1)
CAB Files	559	(1)
Languages	559	(1)
Password	560	(1)
Media	560	(1)
Distribution Group	560	(1)
Wise Update	560	(1)
Installation Expert Summary	561	(1)
WiseScript	561	(4)
Script Editor	561	(1)
Include Files	562	(1)
Remark	562	(1)
Check If File/Dir Exists	562	(1)
Set Variable	562	(1)
Get Registry Key Value	563	(1)
Install File(s)	563	(1)
Custom Dialog	564	(1)
Create Shortcut	564	(1)
Self-Register OCXs/DLLs/EXEs	564	(1)
WiseScript Summary	564	(1)
Import VB Project	565	(1)
ApplicationWatch Wizard	565	(1)
Compiling the WiseScript	566	(1)
Conclusion	567	(2)
Appendix D: ADO Object Summary	569	(20)
The Objects	569	(1)
The Command Object	570	(2)
The Connection Object	572	(2)
The Error Object	574	(1)
The Errors Collection	574	(1)
The Field Object	575	(1)
The Fields Collection	576	(1)
The Parameter Object	576	(1)
The Parameters Collection	577	(1)
The Properties Collection	578	(1)
The Property Object	578	(1)
The Record Object	578	(1)
The Recordset Object	579	(4)
The Stream Object	583	(2)
ADO Method Calls -- Quick Reference	585	(1)
Command Object Methods	585	(1)
Connection Object Methods	585	(1)
Errors Collection Methods	585	(1)
Field Object Methods	585	(1)
Fields Collection Methods	585	(1)
Parameter Object Methods	585	(1)
Parameters Collection Methods	586	(1)
Properties Collection Methods	586	(1)
Record Object Methods	586	(1)
Recordset Object Methods	586	(1)
Stream Object Methods	587	(2)
Appendix E: SQL Reference	589	(36)
Notation	589	(1)
SQL Data Types	590	(1)
Character Data Types	590	(1)
Numeric Types	590	(1)
Date/Time Data Types	591	(1)
SQL Sublanguages	591	(1)
Data Definition Language (DDL)	591	(1)
Data Manipulation Language (DML)	592	(1)
Data Control Language (DCL)	592	(1)
ANSI SQL-92	592	(10)
Explicit Transaction Commands	592	(1)
ANSI SQL-92 Commands	592	(9)
ANSI SQL-92 Aggregate Functions	601	(1)
SQL Server and Transact-SQL	602	(11)
General ANSI SQL-92 Compatibility	602	(1)
Distributed Queries	602	(1)
Entity Naming Scheme	602	(1)
Explicit Transaction Commands	603	(1)
ANSI SQL-92 Commands in Transact-SQL	603	(7)
ANSI SQL-92 Functions in Transact-SQL	610	(1)
Aggregate Functions	610	(1)
Non-ANSI SQL-92 Mathematical Functions	611	(1)
String-related functions	612	(1)
Date and Time Functions	613	(1)
Conversion Functions	613	(1)
Other Unlisted Functions	613	(1)
Commands Not Part of ANSI SQL-92	613	(3)
Data Types	615	(1)
Other SQL Server Data Types	615	(1)
Microsoft Access Database Engine (Jet)	616	(9)
General SQL-92 Compatibility Issues	617	(1)
ANSI SQL-92 Commands	617	(4)
ANSI SQL-92 Functions in Microsoft Access	621	(1)
Non ANSI SQL-92 Mathematical Functions	622	(1)
String-related Functions	622	(1)
Date and Time Functions	622	(1)
Conversion Functions	622	(1)
Commands Not Part of ANSI SQL-92	622	(1)
Data Types	623	(2)
Index	625