Winsql
Páginas: 116 (28914 palabras)
Publicado: 6 de septiembre de 2010
Synametrics Technologies
WinSQL® Professional User’s Guide
Version 7.5
February 21, 2009
Copyright notice
Copyright © 2009 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 containconfidential, 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. Thisdocumentation and related software are subject to change without notice.
Publication date
February 2009
Product and version
WinSQL Professional 7.5
Reader comments
Any comments or suggestions regarding this publication are should be forwarded to the attention of: 666 Plainsboro Road Suite 356 Plainsboro, NJ 08536 or sent by e-mail to: support@synametrics.com
Trademarks
WinSQL Professionalis 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.
WinSQLProfessional User's Guide Release 7.5
ii
February 2009
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 ............................................. 32 Modifying results displayed in Grid ......................... 33 Modifying results displayed in...
WinSQL® Professional User’s Guide
Version 7.5
February 21, 2009
Copyright notice
Copyright © 2009 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 containconfidential, 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. Thisdocumentation and related software are subject to change without notice.
Publication date
February 2009
Product and version
WinSQL Professional 7.5
Reader comments
Any comments or suggestions regarding this publication are should be forwarded to the attention of: 666 Plainsboro Road Suite 356 Plainsboro, NJ 08536 or sent by e-mail to: support@synametrics.com
Trademarks
WinSQL Professionalis 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.
WinSQLProfessional User's Guide Release 7.5
ii
February 2009
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 ............................................. 32 Modifying results displayed in Grid ......................... 33 Modifying results displayed in...
Leer documento completo
Regístrate para leer el documento completo.