Contents
Search
WinSQL Professional User's Guide
Welcome
About This Document
Chapter 1: Getting Started
Overview
Requirements
Installation and Set Up
Obtaining a Serial Number
Registering WinSQL Professional ODBC Drivers
Configuring ODBC
Creating ODBC Connections
Establishing a Database Connection
Connection Strings
Sample Connection Strings
Connection Options
Uninstalling WinSQL Professional
Customizing Shortcut Keys
Chapter 2: Running Queries
Overview
Screen Layout
Integrated View
Classic View
Writing SQL Scripts
Query Pages
Using Clipboard
Displaying Query Results
Viewing BLOB/CLOB Data
Searching for Text
Printing Results
Exporting Grid Content
Intelli Tips
Table Joins
Data Lookup
Configuring Data Lookup Display Options
Modifying SQL Queries to Retrieve Data
Drill-down Results
Query History
Comments with SQL Statements
Query Syntax and SQL Grammar
Parameterized Queries
Generate Code
SQL Wizard
Show Native SQL
Scripting Wizard
Chapter 3: Configuration Options
Overview
General Tab
SQL Editor Tab
Intelli Tips Tab
Advanced Options Tab
Chapter 4: Supported Functions
Overview
Scalar Functions
String Functions
Numeric Functions
Time, Date, and Interval Functions
System Functions
Chapter 5: Database Catalog
Overview
About the Database Catalog
Asynchronous Catalog Fetching
Viewing the Database Catalog
Exploring Objects in the Catalog
Providing Filters
Browsing Data
Applying Filters
Adding User Comments
Using the Insert/Update Record Wizard
Using Strings and Dates
Ignoring Fields and NULL Values
Adding BLOB and CLOB Data
Managing Relationships
Creating Local Relationships
Deleting Relationships
Executing Stored Procedures
Using the New Table Wizard
Reverse Engineering a Table Design
Printing
Database Search Wizard
Using the Database Search Wizard
Chapter 6: Using the Database Task Scheduler
Overview
About the Task Scheduler
Types of Tasks
Creating a Task to Run a SQL Script
Chapter 7: Publishing HTML Pages
Overview
Using Export Templates
Creating a New HTML Template
Using an Existing HTML Template
Chapter 8: Using Database Diff
Overview
Database Diff Wizards
Schema Diff Wizard
Data Diff Wizard
Chapter 9: Generating Test Data
Overview
Creating a Test Environment
Starting the Test Data Generation Wizard
Specifying Formatted Data
Chapter 10: Entity-Relationship Diagrams
Overview
Creating an E/R Diagram
Chapter 11: Exporting and Importing Data
Overview
Exporting Data
Exporting Data to another Data Source
Exporting Data from a SQL Query
Exporting to an External Database
Using Existing Templates
Exporting to an Executable File
Generating Parameterized Executables
Importing Text Files
Importing a Delimited Text File
Importing a Fixed Width Text File
Importing from Microsoft Excel
Chapter 12: Offline Backup/Restore
Overview
Backing Up a Database
Restoring a Database
Chapter 13: Database-Specific Plug-Ins
Overview
Overview of Database Plug-Ins
Chapter 14: Administrative Tasks
Overview
Wizards Used For Administrative Tasks
Available Wizards
Chapter 15: Command Line Processing
Overview
Command Line Options
Command Line Syntax
Command Line Examples
Running Scripts From a Command Line
Script Functions
Sample Scripts
Troubleshooting Common Problems
Enter your search term:
Match:
Any words
Phrase