Professional Visual Basic 6 : A Programmer's Resource,9781861008183

Professional Visual Basic 6 : A Programmer's Resource

by ; ; ; ; ;
Edition: CD
ISBN13: 9781861008183
ISBN10: 186100818X
Format: Trade Paper
Pub. Date: 2003-01-07
Publisher(s): Springer-Verlag New York Inc
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $59.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $49.76

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.