Extended Copy - Code

WinSQL Professional allows you to copy SQL code into HTML or Rich Text format using the Extended Copy option in the Query window.  You can also convert code using the Convert to Code option.

The following topics describe these options.

Convert to Code

This option allows you to write SQL code and convert that code into a third-generation language, such as C-Sharp, Visual Basic, or Java.

Perform the following steps to convert SQL code:

1          Right-click the desired script in the Query window, and then click Extended Copy.

2          Click Convert to Code. The SQL2Code Wizard window displays:

3          Select the desired language in the Language drop-down list.

4          If desired, change the default variable name in the Variable Name field.

5          Click Copy to copy the text to the clipboard.

Copy to Rich Text

This option copies SQL code to the Windows Clipboard in Rich Text format, which allows you to paste SQL code to different applications, such as a word processing application that uses Rich Text format.

To copy SQL code into Rich Text format, right-click the desired script in the Query windows, click Extended Copy, and then choose Rich Text.

Copy to HTML

This option converts the SQL code into HTML, while retaining all syntax highlighting, and provides a convenient way of creating HTML documentation.

To copy SQL statements into HTML, right-click the desired script in the Query windows, click Extended Copy, and then choose HTML.