| sample database : about | The sample database |
| SATMP environment variable | SATMP environment variable |
| SAVEPOINT statement : syntax | SAVEPOINT statement |
| savepoints : about | Statement elements |
| savepoints : RELEASE SAVEPOINT statement | RELEASE SAVEPOINT statement |
| savepoints : ROLLBACK TO SAVEPOINT statement | ROLLBACK TO SAVEPOINT statement |
| saving statements | ISQL_LOG option [ISQL |
| sa_conn_info system procedure | System and catalog stored procedures sa_conn_info system procedure |
| sa_conn_properties : using | Finding option settings |
| sa_conn_properties system procedure | System and catalog stored procedures sa_conn_properties system procedure sa_conn_properties_by_conn system procedure |
| sa_conn_properties_by_name system procedure | sa_conn_properties_by_name system procedure |
| sa_db_info system procedure | System and catalog stored procedures sa_db_info system procedure |
| sa_db_properties system procedure | System and catalog stored procedures sa_db_properties system procedure |
| sa_eng_properties system procedure | System and catalog stored procedures sa_eng_properties system procedure |
| sa_table_page_usage procedure | System and catalog stored procedures |
| sa_table_page_usage system procedure | sa_table_page_usage system procedure |
| sa_validate system procedure | System and catalog stored procedures sa_validate system procedure |
| SCALE option | General database options SCALE option |
| scan_retry parameter | The LTM configuration file |
| scheduling : server shutdown | -tq time command-line option |
| schema : and system tables | CHAPTER 15. System Tables |
| schema : creating | CREATE SCHEMA statement |
| SCROLL cursors | DECLARE CURSOR statement [ESQL] [SP] |
| search conditions : about | Search conditions |
| search conditions : ALL conditions | ALL or ANY conditions |
| search conditions : ANY conditions | ALL or ANY conditions |
| search conditions : BETWEEN conditions | BETWEEN conditions |
| search conditions : comparison conditions | Comparison conditions |
| search conditions : EXISTS conditions | EXISTS conditions |
| search conditions : IN conditions | IN conditions |
| search conditions : IS NULL conditions | IS NULL conditions |
| search conditions : LIKE conditions | LIKE conditions |
| search conditions : NOT conditions | NOT conditions |
| search conditions : subqueries | Subqueries in search conditions |
| search conditions : three-valued logic | Three-valued logic |
| search conditions : truth value conditions | Truth value conditions |
| SEARCHBINDERY communication parameter | SEARCHBINDERY parameter [BINSEARCH] |
| SECOND function | SECOND function [Date and time] |
| SECONDS function | SECONDS function [Date and time] |
| security : auditing | AUDITING option |
| security : minimum password length | MIN_PASSWORD_LENGTH option |
| secutiry : encrypting communications | - e command-line option |
| select list : DESCRIBE statement | DESCRIBE statement [ESQL] |
| select list : SELECT statement | SELECT statement |
| SELECT statement : examples | CHAPTER 16. System Views |
| SELECT statement : FROM clause syntax | FROM clause |
| SELECT statement : syntax | SELECT statement |
| server messages : displaying | - q command-line option |
| server messages : output to file | - o command-line option |
| server name | - n command-line option |
| ServerName connection parameter | EngineName connection parameter [ENG] ServerName connection parameter [ENG] |
| ServerPort communication parameter | SERVERPORT parameter [ PORT] |
| servers : creating | CREATE SERVER statement |
| servers : locating | The DBPing utility |
| servers : properties of | Properties available for the server |
| services : registry entries | Current user and local machine settings |
| services : Windows 95 | - y command-line option |
| SESSIONS communication parameter | SESSIONS parameter |
| SET CONNECTION statement : syntax | SET CONNECTION statement [ISQL][ESQL] |
| SET DEFAULT | CREATE TABLE statement |
| SET DESCRIPTOR statement : syntax | SET DESCRIPTOR statement [ESQL] |
| SET NULL action | CREATE TABLE statement |
| SET OPTION statement : Interactive SQL syntax | Interactive SQL options |
| SET OPTION statement : syntax | Introduction to database options SET OPTION statement SET OPTION statement [ISQL] |
| SET OPTION statement : Transact-SQL | SET statement [T-SQL] |
| SET OPTION statement : using | Setting options |
| SET SQLCA statement : syntax | SET SQLCA statement [ESQL] |
| SET statement : syntax | SET statement SET statement [T-SQL] |
| SET statement : Transact-SQL | SET statement [T-SQL] |
| SET TEMPORARY OPTION statement : Interactive SQL syntax | Interactive SQL options |
| SET TEMPORARY OPTION statement : syntax | Introduction to database options SET OPTION statement SET OPTION statement [ISQL] |
| SETUSER statement : setting | SETUSER statement |
| shared memory : about | - x command-line option |
| show_role Adaptive Server Enterprise function | Connection properties |
| shutdown : specifying time | -tq time command-line option |
| SIGN function | SIGN function [Numeric] |
| SIGNAL statement : syntax | SIGNAL statement |
| signatures : Java methods | CREATE PROCEDURE statement |
| SIMILAR function | SIMILAR function [String] |
| SIN function | SIN function [Numeric] |
| SMALLDATETIME data type : about | DATETIME data type [Date and Time] SMALLDATETIME data type [Date and Time] |
| SMALLINT data type : about | SMALLINT data type [Numeric] |
| software : DBCOLLAT | The DBCOLLAT command-line utility |
| software : DBERASE | The Erase utility |
| software : DBINFO | The DBINFO command-line utility |
| software : DBLOG | The DBLOG command-line utility |
| software : DBPING | The DBPing utility |
| software : DBSHRINK | The DBSHRINK command-line utility |
| software : DBTRAN | The DBTRAN command-line utility |
| software : DBUNLOAD | The DBUNLOAD command-line utility |
| software : DBUPGRAD | The DBUPGRAD command-line utility |
| software : Interactive SQL | The Interactive SQL utility |
| software : REBUILD | The REBUILD component |
| software : return codes | Software component Return codes |
| software version : database server | - v command-line option |
| SOME conditions | ALL or ANY conditions |
| sorting : in the system tables | SYSCOLLATION system table |
| SOUNDEX function | SOUNDEX function [String] |
| SPACE function | SPACE function [Miscellaneous] |
| special characters : in strings | Statement elements |
| special tables | CHAPTER 15. System Tables |
| sp_addgroup system procedure | Adaptive Server Enterprise system procedures |
| sp_addlogin system procedure | Adaptive Server Enterprise system procedures |
| sp_addmessage system procedure | CREATE MESSAGE statement [T-SQL] Adaptive Server Enterprise system procedures |
| sp_addtype system procedure | Adaptive Server Enterprise system procedures |
| sp_adduser system procedure | Adaptive Server Enterprise system procedures |
| sp_changegroup system procedure | Adaptive Server Enterprise system procedures |
| sp_columns catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_column_privileges : catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_column_privileges catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_dboption system procedure | Adaptive Server Enterprise system procedures |
| sp_dropgroup system procedure | Adaptive Server Enterprise system procedures |
| sp_droplogin system procedure | Adaptive Server Enterprise system procedures |
| sp_dropmessage system procedure | Adaptive Server Enterprise system procedures |
| sp_droptype system procedure | Adaptive Server Enterprise system procedures |
| sp_dropuser system procedure | Adaptive Server Enterprise system procedures |
| sp_fkeys catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_getmessage system procedure | Adaptive Server Enterprise system procedures |
| sp_helptext system procedure | Adaptive Server Enterprise system procedures |
| sp_login_environment procedure | System and catalog stored procedures |
| sp_login_environment system procedure | sp_login_environment system procedure |
| sp_password system procedure | Adaptive Server Enterprise system procedures |
| sp_pkeys catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_remote_columns system procedure | sp_remote_columns system procedure |
| sp_remote_tables system procedure | sp_remote_tables system procedure |
| sp_servercaps system procedure | sp_servercaps system procedure |
| sp_special_columns catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_sproc_columns catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_stored_procedures catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_tables catalog procedure | Adaptive Server Enterprise catalog procedures |
| sp_tsql_environment | System and catalog stored procedures |
| sp_tsql_environment system procedure | sp_tsql_environment system procedure |
| SQL : language elements | CHAPTER 6. SQL Language Elements |
| SQL : SQL/92 syntax | The SQL preprocessor |
| SQL : statements | CHAPTER 9. SQL Statements |
| SQL : syntax conventions | Using the SQL statement reference |
| SQL compatibility : ANSI_CLOSE_CURSORS_ON_ROLLBACK option | ANSI_CLOSE_CURSORS_ON_ROLLBACK option |
| SQL preprocessor : about | The SQL preprocessor |
| SQL preprocessor : command line | The SQL preprocessor |
| SQL Remote : articles | SYSARTICLE system table SYSARTICLECOL system table |
| SQL Remote : options | Replication options |
| SQL Remote : system tables | SYSARTICLE system table SYSARTICLECOL system table |
| SQL variables : creating | CREATE VARIABLE statement |
| SQL variables : dropping | DROP VARIABLE statement |
| SQL variables : SET VARIABLE statement | SET statement |
| SQL/92 : conformance | The SQL preprocessor SQL_FLAGGER_ERROR_LEVEL option |
| SQLCA : INCLUDE statement | INCLUDE statement [ESQL] |
| SQLCA : SET SQLCA statement | SET SQLCA statement [ESQL] |
| SQLCODE : default | Constants in expressions |
| SQLCODE : special constant | Constants in expressions |
| SQLCODE : values | CHAPTER 10. Database Error Messages |
| SQLCONNECT environment variable | SQLCONNECT environment variable |
| SQLDA : allocating memory | ALLOCATE DESCRIPTOR statement [ESQL] |
| SQLDA : and ANSI_BLANKS | ANSI_BLANKS option |
| SQLDA : deallocating | DEALLOCATE DESCRIPTOR statement [ESQL] |
| SQLDA : DESCRIBE statement | DESCRIBE statement [ESQL] |
| SQLDA : Execute statement | EXECUTE statement [ESQL] |
| SQLDA : INCLUDE statement | INCLUDE statement [ESQL] |
| SQLDA : PUT statement | PUT statement [ESQL] [SP] |
| SQLDA : setting | SET DESCRIPTOR statement [ESQL] |
| SQLDA : UPDATE (positioned) statement | UPDATE (positioned) statement |
| SQLLOCALE environment variable | SQLLOCALE environment variable |
| SQLPATH environment variable | SQLPATH environment variable |
| SQLPP : command line | The SQL preprocessor |
| SQLREMOTE environment variable | SQLREMOTE environment variable |
| SQLSTATE : default | Constants in expressions |
| SQLSTATE : special constant | Constants in expressions |
| SQLSTATE : values | Error messages index by SQLSTATE |
| SQL_database parameter | The LTM configuration file |
| SQL_FLAGGER_ERROR_LEVEL option | SQL_FLAGGER_ERROR_LEVEL option |
| SQL_FLAGGER_WARNING_LEVEL option | SQL_FLAGGER_WARNING_LEVEL option |
| SQL_pw parameter | The LTM configuration file |
| SQL_server parameter | The LTM configuration file |
| SQL_user parameter | The LTM configuration file |
| SQRT function | SQRT function [Miscellaneous] |
| stack overflow : errors | -gss command-line option |
| stack size : external functions | -ge command-line option |
| stack size : maximum | -gss command-line option |
| START DATABASE statement : syntax | START DATABASE statement [ISQL] |
| START ENGINE statement : syntax | START ENGINE statement [ISQL] |
| START JAVA statement : syntax | START JAVA statement |
| starting : database servers | START ENGINE statement [ISQL] |
| starting : databases | START DATABASE statement [ISQL] |
| starting : Java VM | START JAVA statement |
| StartLine connection parameter | StartLine connection parameter [START] |
| statement labels | Statement elements GOTO statement [T-SQL] |
| static cursors : declaring | DECLARE CURSOR statement [ESQL] [SP] |
| statistics : available | Monitoring database statistics from the Windows NT Performance Monitor |
| statistics : displaying | Monitoring database statistics from the Windows NT Performance Monitor |
| statistics : Interactive SQL option | STATISTICS option [ISQL |
| statistics : monitoring | Monitoring database performance |
| STATS communication parameter | THREADSTATS parameter [STATS] |
| stop : utility | The Stop utility |
| STOP DATABASE statement : syntax | STOP DATABASE statement [ISQL] |
| STOP ENGINE statement : syntax | STOP ENGINE statement [ISQL] |
| STOP JAVA statement : syntax | STOP JAVA statement |
| stopping : Java VM | STOP JAVA statement |
| stopping databases | The DBSTOP command-line utility STOP DATABASE statement [ISQL] |
| stored procedures : creating | CREATE PROCEDURE statement |
| STR function | STR function [String] |
| STRING function | STRING function [String] |
| string functions | String functions |
| string truncation : database option | STRING_RTRUNCATION option |
| strings : about | Statement elements |
| strings : and host variables | ANSI_BLANKS option |
| strings : concatenating | String operators |
| strings : concatenation operators | String operators |
| strings : constants | Statement elements Constants in expressions |
| strings : delimiter | Compatibility of expressions |
| strings : literal strings | Statement elements |
| strings : special characters | Statement elements |
| strings : Transact-SQL | Compatibility of expressions |
| STUFF function | STUFF function [String] |
| subqueries : in expressions | Subqueries in expressions |
| subqueries : in search conditions | Subqueries in search conditions |
| SUBSCRIBE_BY_REMOTE : replication option | SUBSCRIBE_BY_REMOTE option |
| subscriptions : updates | UPDATE statement |
| SUBSTR function | SUBSTR function [String] |
| SUM function | SUM function [Aggregate] |
| suser_id Adaptive Server Enterprise function | Connection properties |
| suser_name Adaptive Server Enterprise function | Connection properties |
| Sybase Central : monitoring performance | Monitoring database statistics from Sybase Central |
| Sybase Central : quoted identifiers | QUOTED_IDENTIFIER option |
| Sybase Central : registry entries | Registry settings on installation |
| Sybase Central : starting Interactive SQL from | Starting Interactive SQL from Sybase Central |
| Sybase Central : syntax highlighting | PERCENT_AS_COMMENT option |
| SYBASE environment variable | SYBASE environment variable |
| SyncWriteChkpt property | Connection properties Properties available for the server |
| SyncWriteExtend property | Connection properties Properties available for the server |
| SyncWriteFreeCurr property | Connection properties Properties available for the server |
| SyncWriteFreePush property | Connection properties Properties available for the server |
| SyncWriteLog property | Connection properties Properties available for the server |
| SyncWriteRlbk property | Connection properties Properties available for the server |
| SyncWriteUnkn property | Connection properties Properties available for the server |
| syntax conventions | Using the SQL statement reference |
| syntax highlighiting : comments | PERCENT_AS_COMMENT option |
| syntax rules | CHAPTER 6. SQL Language Elements |
| SYS group : in the system tables | SYSUSERPERM system table |
| syslog : user ID for | - s command-line option |
| sysservers system table : remote servers for Component Integration Services | CREATE SERVER statement CREATE SERVER statement |
| system calls : from stored procedures | xp_cmdshell system procedure |
| system calls : xp_cmdshell system procedure | xp_cmdshell system procedure |
| system catalog | SYSCATALOG system view |
| system catalog : about | CHAPTER 15. System Tables |
| system catalog : diagram | System tables diagram |
| system catalog : list | System table descriptions |
| system catalog : Transact-SQL | Views for Transact-SQL Compatibility |
| system functions | System functions Connection properties |
| system objects : and the dbo user | The Unload utility |
| system procedures : about | CHAPTER 14. System Procedures and Functions |
| System procedures : catalog list | System and catalog stored procedures |
| system procedures : extended, list | System extended stored procedures |
| System procedures : overview | System procedure overview |
| system procedures : sa_conn_info | System and catalog stored procedures sa_conn_info system procedure |
| system procedures : sa_conn_properties | sa_conn_properties system procedure sa_conn_properties_by_conn system procedure |
| system procedures : sa_conn_properties_by_name | sa_conn_properties_by_name system procedure |
| system procedures : sa_db_info | System and catalog stored procedures sa_db_info system procedure |
| system procedures : sa_db_properties | sa_db_properties system procedure |
| system procedures : sa_eng_properties | sa_eng_properties system procedure |
| system procedures : sa_table_page_usage | sa_table_page_usage system procedure |
| system procedures : sa_validate | sa_validate system procedure |
| system procedures : sp_addgroup | Adaptive Server Enterprise system procedures |
| system procedures : sp_addlogin | Adaptive Server Enterprise system procedures |
| system procedures : sp_addmessage | Adaptive Server Enterprise system procedures |
| system procedures : sp_addtype | Adaptive Server Enterprise system procedures |
| system procedures : sp_adduser | Adaptive Server Enterprise system procedures |
| system procedures : sp_changegroup | Adaptive Server Enterprise system procedures |
| system procedures : sp_dboption | Adaptive Server Enterprise system procedures |
| system procedures : sp_dropgroup | Adaptive Server Enterprise system procedures |
| system procedures : sp_droplogin | Adaptive Server Enterprise system procedures |
| system procedures : sp_dropmessage | Adaptive Server Enterprise system procedures |
| system procedures : sp_droptype | Adaptive Server Enterprise system procedures |
| system procedures : sp_dropuser | Adaptive Server Enterprise system procedures |
| system procedures : sp_getmessage | Adaptive Server Enterprise system procedures |
| system procedures : sp_helptext | Adaptive Server Enterprise system procedures |
| system procedures : sp_login_environment | sp_login_environment system procedure |
| system procedures : sp_password | Adaptive Server Enterprise system procedures |
| system procedures : sp_remote_columns | sp_remote_columns system procedure |
| system procedures : sp_remote_tables | sp_remote_tables system procedure |
| system procedures : sp_servercaps | sp_servercaps system procedure |
| system procedures : sp_tsql_environment | sp_tsql_environment system procedure |
| system procedures : Transact-SQL | Adaptive Server Enterprise system procedures |
| system procedures : Transact-SQL list | Adaptive Server Enterprise system and catalog procedures |
| system procedures : xp_scanf | xp_scanf system procedure |
| system procedures : xp_startmail | xp_startmail system procedure |
| SYSTEM statement : syntax | SYSTEM statement [ISQL] |
| system tables : about | CHAPTER 15. System Tables |
| system tables : diagram | System tables diagram |
| System tables : DUMMY | DUMMY system table |
| system tables : list | System table descriptions |
| system tables : SYSARTICLE | SYSARTICLE system table |
| system tables : SYSARTICLECOL | SYSARTICLECOL system table |
| system tables : SYSCOLLATE | SYSCOLLATION system table |
| system tables : SYSCOLPERM | SYSCOLPERM system table |
| system tables : SYSCOLUMN | SYSCOLUMN system table |
| system tables : SYSDOMAIN | SYSDOMAIN system table |
| system tables : SYSEXTENT | SYSEXTENT system table |
| system tables : SYSEXTERNLOGINS | SYSEXTERNLOGINS system table |
| system tables : SYSFILE | SYSFILE system table |
| system tables : SYSFKCOL | SYSFKCOL system table |
| system tables : SYSFOREIGNKEY | SYSFOREIGNKEY system table |
| system tables : SYSGROUP | SYSGROUP system table |
| system tables : SYSINDEX | SYSINDEX system table |
| system tables : SYSINFO | SYSINFO system table |
| system tables : SYSIXCOL | SYSIXCOL system table |
| system tables : SYSJAR | SYSJAR system table |
| system tables : SYSJARCOMPONENT | SYSJARCOMPONENT system table |
| system tables : SYSJAVACLASS | SYSJAVACLASS system table |
| system tables : SYSLOGIN | SYSLOGIN system table |
| system tables : SYSOPTION | SYSOPTION system table |
| system tables : SYSPROCEDURE | SYSPROCEDURE system table |
| system tables : SYSPROCPARM | SYSPROCPARM system table |
| system tables : SYSPROCPERM | SYSPROCPERM system table |
| system tables : SYSPUBLICATION | SYSPUBLICATION system table |
| system tables : SYSREMOTETYPE | SYSREMOTETYPE system table |
| system tables : SYSREMOTEUSER | SYSREMOTEUSER system table |
| system tables : SYSSERVERS | SYSSERVERS system table |
| system tables : SYSSQLSERVERTYPE | SYSSQLSERVERTYPE system table |
| system tables : SYSSUBSCRIPTION | SYSSUBSCRIPTION system table |
| system tables : SYSTABLE | SYSTABLE system table |
| system tables : SYSTABLEPERM | SYSTABLEPERM system table |
| system tables : system views | CHAPTER 16. System Views |
| system tables : SYSTRIGGER | SYSTRIGGER system table |
| system tables : SYSTYPEMAP | SYSTYPEMAP system table |
| system tables : SYSUSERMESSAGES | SYSUSERMESSAGES system table |
| system tables : SYSUSERPERM | SYSUSERPERM system table |
| system tables : SYSUSERTYPE | SYSUSERTYPE system table |
| system tables : Transact-SQL | Views for Transact-SQL Compatibility |
| system tables; SYSCOLLATIONMAPPINGS | SYSCOLLATIONMAPPINGS system table |
| system variables | Global variables |
| system views : about | CHAPTER 16. System Views |
| system views : SYSARTICLECOLS | SYSARTICLECOLS system view |
| system views : SYSARTICLES | SYSARTICLES system view |
| system views : SYSCATALOG | SYSCATALOG system view |
| system views : SYSCOLAUTH | SYSCOLAUTH system view |
| system views : SYSCOLUMNS | SYSCOLUMNS system view |
| system views : SYSFOREIGNKEYS | SYSFOREIGNKEYS system view |
| system views : SYSGROUPS | SYSGROUPS system view |
| system views : SYSINDEXES | SYSINDEXES system view |
| system views : SYSOPTIONS | SYSOPTIONS system view |
| system views : SYSPROCAUTH | SYSPROCAUTH system view |
| system views : SYSPROCPARMS | SYSPROCPARMS system view |
| system views : SYSPUBLICATIONS | SYSPUBLICATIONS system view |
| system views : SYSREMOTETYPES | SYSREMOTETYPES system views |
| system views : SYSREMOTEUSERS | SYSREMOTEUSERS system view |
| system views : SYSSUBSCRIPTIONS | SYSSUBSCRIPTIONS system view |
| system views : SYSTABAUTH | SYSTABAUTH system view |
| system views : SYSTRIGGERS | SYSTRIGGERS system view |
| system views : SYSUSERAUTH | SYSUSERAUTH system view |
| system views : SYSUSERLIST | SYSUSERLIST system view |
| system views : SYSUSEROPTIONS | SYSUSEROPTIONS system view |
| system views : SYSUSERPERMS | SYSUSERPERMS system view |
| system views : SYSVIEWS | SYSVIEWS system view |