WinSQL Professional User's Guide v8

Synametrics Technologies

WinSQL? Professional User's Guide

Version 8.5

August 20, 2010

Copyright notice

Copyright ? 2010 Synametrics Technologies, a division of IndusSoft Technologies, Inc. and/or one of its subsidiaries. All rights reserved.

Use of this documentation and related software is governed by a license agreement. This documentation and related software contain confidential, proprietary and trade secret information of Synametrics Technologies and are protected under United States and international copyright and other intellectual property laws. Use, disclosure, reproduction, modification, distribution, or storage in a retrieval system in any form or by any means is prohibited without the prior express written permission of Synametrics Technologies. This documentation and related software are subject to change without notice.

Publication date

August 2010

Product and version

WinSQL Professional 8.5

Reader comments

Any comments or suggestions regarding this publication are should be forwarded to the attention of:

666 Plainsboro Road Suite 656 Plainsboro, NJ 08536

or sent by e-mail to: support@

Trademarks

WinSQL Professional is a registered trademark of Synametrics Technologies, a division of IndusSoft Technologies, Inc. Portions of this software are copyrighted by DataDirect Technologies. Windows is a registered trademark of Microsoft Corporation in the United States and/or other countries.

All other product or company names may be trademarks or registered trademarks of their respective companies.

WinSQL Professional User's Guide

ii

Release 8.5

August 2010

WinSQL Professional User's Guide

Table of Contents

Table of Contents

About This Document................................................viii

Document Conventions...................................................ix

Chapter 1: Getting Started ...........................................1

Overview ........................................................................... 1 Requirements ................................................................... 2 Installation and Set Up .................................................... 3 Obtaining a Serial Number ............................................. 4 Registering WinSQL Professional ODBC Drivers....... 5 Configuring ODBC ........................................................... 7

Creating ODBC Connections..................................... 7 Establishing a Database Connection .......................... 10

Connection Strings.................................................... 11 Sample Connection Strings ..................................... 12 Connection Options .................................................. 17 Uninstalling WinSQL Professional .............................. 19 Customizing Shortcut Keys .......................................... 20

Chapter 2: Running Queries ......................................23

Overview ......................................................................... 23 Screen Layout ................................................................ 25

Integrated View.......................................................... 25 Classic View............................................................... 26 Switching Views......................................................... 26 Writing SQL Scripts ....................................................... 27 Query Pages................................................................... 28 Query Set Workbook ................................................ 28 Using Clipboard.............................................................. 29 Extended Copy - Code ............................................. 29 Extended Copy - Results ......................................... 30 Displaying Query Results ............................................. 31 Modifying results displayed in Grid......................... 32 Modifying results displayed in Text......................... 32 Modifying results displayed in Form ....................... 32 Viewing BLOB/CLOB Data ...................................... 33 Searching for Text ......................................................... 37

WinSQL Professional User's Guide

August 2010

Release 8.5

iii

Table of Contents

WinSQL Professional User's Guide

Printing Results .............................................................. 39 Exporting Grid Content ................................................. 41 Intelli Tips ........................................................................ 42

Table Joins ................................................................. 43 Data Lookup ................................................................... 44

Configuring Data Lookup Display Options ............ 44 Modifying SQL Queries to Retrieve Data .............. 47 Drill-down Results .......................................................... 49 Query History.................................................................. 52 Comments with SQL Statements............................ 52 Query Syntax and SQL Grammar........................... 52 Parameterized Queries ................................................. 54 Generate Code............................................................... 55 SQL Wizard .................................................................... 57 Show Native SQL ...................................................... 57 Scripting Wizard ............................................................. 58

Chapter 3: Configuration Options .............................60

Overview ......................................................................... 60 General Tab.................................................................... 61 SQL Editor Tab .............................................................. 66 Editor Options Tab......................................................... 67 Intelli Tips Tab ................................................................ 70 Advanced Options Tab ................................................. 71

Chapter 4: Supported Functions ...............................73

Overview ......................................................................... 73 Scalar Functions ............................................................ 74

String Functions......................................................... 75 Numeric Functions .................................................... 77 Time, Date, and Interval Functions......................... 79 System Functions...................................................... 82

Chapter 5: Database Catalog .....................................83

Overview ......................................................................... 83 About the Database Catalog ........................................ 85

Database Catalog Caching ...................................... 85 Enabling Catalog Caching ....................................... 86 Viewing the Database Catalog .................................... 88 Exploring Objects in the Catalog............................. 89

WinSQL Professional User's Guide

iv

Release 8.5

August 2010

WinSQL Professional User's Guide

Table of Contents

August 2010

Providing Filters ......................................................... 89 Browsing Data ........................................................... 90 Using the Quick Math Feature................................. 90 Applying Filters .......................................................... 91 Adding User Comments ........................................... 91 Creating Local and Shared Comments.................. 92 Using the Insert/Update Record Wizard..................... 94 Using Strings and Dates .......................................... 94 Ignoring Fields and NULL Values ........................... 95 Adding BLOB and CLOB Data ................................ 95 Managing Relationships ............................................... 97 Creating Local Relationships................................... 97 Deleting Relationships.............................................. 99 Executing Stored Procedures .................................... 100 Using the New Table Wizard...................................... 101 Reverse Engineering a Table Design ....................... 102 Printing .......................................................................... 103 Database Search Wizard............................................ 104 Using the Database Search Wizard ..................... 104

Chapter 6: Using the Database Task Scheduler ....106

Overview ....................................................................... 106 About the Task Scheduler .......................................... 107

Types of Tasks ........................................................ 107 Creating a Task to Run a SQL Script ....................... 108

Chapter 7: Publishing HTML Pages ........................113

Overview ....................................................................... 113 Using Export Templates ............................................. 114

Creating a New HTML Template .......................... 114 Using an Existing HTML Template ....................... 117

Chapter 8: Using Database Diff ...............................118

Overview ....................................................................... 118 Database Diff Wizards ................................................ 119

Schema Diff Wizard ................................................ 119 Comparing Objects Using Schema Diff ............... 124 Primary Objects and Detail Options ..................... 124 Data Diff Wizard ........................................................... 125 Comparing Objects Using Data Diff ..................... 128

WinSQL Professional User's Guide

Release 8.5

v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download