|
|
|
Query Window - Server Side Comments
Aqua Data Studio supports client side and server
side comments. Prior to version 3.5 ADS treated all comments as client
side comments. Client side comments are comments which ADS removes from an
SQL statement before executing (or sending) them on to the server database.
Server side comments are comments which are executed (sent) to the server
with the SQL statement. The reason for server side comments is to support
comments stored in stored procedures. When creating stored procedures that
include comments, ADS needs to include the comments in the SQL statement
that is executed on the server. ADS supports 3 types of comments:
1: Block Comment -> /* Block Comment */
2: Line Comment -> -- Line Comment
3: Line Comment -> // Line Comment
|
Server Side Comments
|
ADS comments are configurable ... since different databases
support different types of comments. In the options dialog box, a user may
select each type of comment to be a client or server side comment per
database. You may view what statement and comments will be executed on the
server with an "Execute Parse" on a statement/script before executing. Below is a
list of databases, what comment types they support and the default value for
each database.
BBSSC: Block Server Side Comment
SSSSC: Slash Slash Server Side Comment
DDSSC: Dash Dash Server Side Comment
|
DB2 - 7.x/8.x
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
FALSE
|
FALSE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
Informix 9.3
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
TRUE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
MS SQL Server 2000
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
TRUE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
MS SQL Server 7
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
TRUE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
MySQL
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
FALSE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
FALSE
|
|
Oracle 8i/9i
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
TRUE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
Postgresql
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
FALSE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
FALSE
|
|
Sybase Anywhere
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
TRUE
|
|
SSSSC: { // }:
|
TRUE
|
TRUE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
Sybase
|
DB SUPPORT
|
ADS DEFAULT
|
|
BBSSC { /* */ }:
|
TRUE
|
TRUE
|
|
SSSSC: { // }:
|
FALSE
|
FALSE
|
|
DDSSC: { -- }:
|
TRUE
|
TRUE
|
|
|
