Quick Reference Guide for ASE

JohnPhan 发表于 2008-2-21 09:47:17

http://pagesperso-orange.fr/laserquest/linux/refidx.html

ehxz 发表于 2008-2-21 10:14:07

<center>
<h1>Quick Reference Guide for ASE</h1></center>
<h1>Dbcc Stored Procs</h1> 
<table border="1" nosave="NOSAVE">
<tbody>
<tr nosave="NOSAVE">
<td nosave="NOSAVE">sp_dbcc_alterws</td>
<td>sp_dbcc_alterws - Changes the size of the specified workspace to a specified value, and initializes the workspace. sp_dbcc_alterws dbname, wsname, "wssize" </td></tr>
<tr>
<td>sp_dbcc_configreport</td>
<td>sp_dbcc_configreport - Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database. sp_dbcc_configreport  </td></tr>
<tr>
<td>sp_dbcc_createws</td>
<td>sp_dbcc_createws - Creates a workspace of the specified type and size on the specified segment and database. sp_dbcc_createws dbname, segname, , wstype, "wssize" </td></tr>
<tr>
<td>sp_dbcc_deletedb</td>
<td>sp_dbcc_deletedb - Deletes from dbccdb all the information related to the specified target database. sp_dbcc_deletedb  </td></tr>
<tr>
<td>sp_dbcc_deletehistory</td>
<td>sp_dbcc_deletehistory - Deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time. sp_dbcc_deletehistory ] </td></tr>
<tr>
<td>sp_dbcc_differentialreport</td>
<td>sp_dbcc_differentialreport - Generates a report that highlights the changes I/O statistics and faults that took place between two dbcc operations. sp_dbcc_differentialreport ], [, "date1" [, "date2"]] </td></tr>
<tr>
<td>sp_dbcc_evaluatedb</td>
<td>sp_dbcc_evaluatedb - Recomputes configuration information for the target database and compares it to the current configuration information. sp_dbcc_evaluatedb  </td></tr>
<tr>
<td>sp_dbcc_faultreport</td>
<td>sp_dbcc_faultreport - Generates a report covering fault statistics for the dbcc checkstorage operations performed for the specified object in the target database on the specified date. sp_dbcc_faultreport ]]] </td></tr>
<tr>
<td>sp_dbcc_fullreport</td>
<td>sp_dbcc_fullreport - Runs sp_dbcc_summaryreport, sp_dbcc_configreport, sp_dbcc_statisticsreport, and sp_dbcc_faultreport short for database..object_name on or before the specified date. sp_dbcc_fullreport ]] </td></tr>
<tr>
<td>sp_dbcc_runcheck</td>
<td>sp_dbcc_runcheck - Runs dbcc checkstorage on the specified database, and then runs sp_dbcc_summaryreport or a report you specify. sp_dbcc_runcheck dbname [, user_proc] </td></tr>
<tr>
<td>sp_dbcc_statisticsreport</td>
<td>sp_dbcc_statisticsreport - Generates an allocation statistics report on the specified object in the target database. sp_dbcc_statisticsreport ]] </td></tr>
<tr>
<td>sp_dbcc_summaryreport</td>
<td>sp_dbcc_summaryreport - Generates a summary report on the specified database. sp_dbcc_summaryreport ] </td></tr>
<tr>
<td>sp_dbcc_updateconfig</td>
<td>sp_dbcc_updateconfig - Updates the dbcc_config table in dbccdb with the configuration information of the target database. sp_dbcc_updateconfig dbname, type, "str1" [, "str2"] </td></tr></tbody></table>
<hr width="100%"/>
[此贴子已经被作者于2008-2-21 10:14:47编辑过]

ehxz 发表于 2008-2-21 10:15:02

<center>
<h1>Quick Reference Guide for ASE</h1></center>
   
ESP Commands  
<table border="1" NOSAVE="NOSAVE" >
<tbody>
<tr NOSAVE="NOSAVE" >
<td NOSAVE="NOSAVE" >xp_cmdshell</td>
<td>xp_cmdshell - Executes a native operating system command on the host system running Adaptive Server. xp_cmdshell command [, no_output] </td></tr>
<tr>
<td>xp_deletemail</td>
<td>xp_deletemail - Deletes a message from the Adaptive Server message inbox. xp_deletemail  </td></tr>
<tr>
<td>xp_enumgroups</td>
<td>xp_enumgroups - Displays groups for a specified Windows NT domain. xp_enumgroups  </td></tr>
<tr>
<td>xp_findnextmsg</td>
<td>xp_findnextmsg - Retrieves the next message identifier from the Adaptive Server message inbox. xp_findnextmsg @msg_id = @msg_id output [, type] [, unread_only = {true | false}] </td></tr>
<tr>
<td>xp_logevent</td>
<td>xp_logevent - Provides for logging a user-defined event in the Windows NT Event Log from within Adaptive Server. xp_logevent error_number, message [, type] </td></tr>
<tr>
<td>xp_readmail</td>
<td>xp_readmail - Reads a message from the Adaptive Server message inbox. xp_readmail [, recipients output] [, sender output] [, date_received output] [, subject output] [, cc output] [, message output] [, attachments output] [, suppress_attach = {true | false}] [, peek = {true | false}] [, unread = {true | false}] [, msg_length output] [, bytes_to_skip ] [, type ] </td></tr>
<tr>
<td>xp_sendmail</td>
<td>xp_sendmail - Sends a message to the specified recipients. The message is either text or the results of a Transact-SQL query. xp_sendmail recipient [, recipient] . . . [, subject] [, cc_recipient] . . . [, bcc_recipient] . . . [, {query | message}] [, attachname] [, attach_result = {true | false}] [, echo_error = {true | false}] [, include_file [, include_file] . . .] [, no_column_header = {true | false}] [, width] [, separator] [, dbuser] [, dbname] [, type] [, include_query = {true | false}] </td></tr>
<tr>
<td>xp_startmail</td>
<td>xp_startmail - Starts an Adaptive Server mail session. xp_startmail [, mail_password] </td></tr>
<tr>
<td>xp_stopmail</td>
<td>xp_stopmail - Stops an Adaptive Server mail session. xp_stopmail </td></tr></tbody></table>

ehxz 发表于 2008-2-21 10:16:03

<center>
<h1>Quick Reference Guide for ASE</h1></center>
   
Unix Utilities  
<table border="1" NOSAVE="NOSAVE" >
<tbody>
<tr>
<td>backupserver</td>
<td>backupserver - The executable form of the Backup Server program. backupserver [-Cserver_connections] [-Sb_servername] [-Iinterfaces_file] [-eerror_log_file] [-Msybmultbuf_binary] [-Nnetwork_connections] [-Ttrace_value] [-LSybase_language_name] [-JSybase_character_set_name] [-ctape_config_file] [-V{0|1|2|3}] or backupserver -v </td></tr>
<tr>
<td>bcp</td>
<td>bcp - Copies a database table to or from an operating system file in a user- specified format. bcp [owner.]] {in | out} datafile [-c] [-E] [-n] [-N] [-X] [-a display_charset] [-A packet_size] [-b batchsize] [-e errfile] [-f formatfile] [-g id_start_value] [-I interfaces_file] [-J client_charset] [-m maxerrors] [-P password] [-q datafile_charset] [-R remote_server_principal] [-S server] [-t field_terminator] [-T text_or_image_size] [-U username] [-z language] or bcp -v </td></tr>
<tr>
<td>buildmaster</td>
<td>buildmaster - Builds the master device and creates the master, model, and tempdb databases on the device. buildmaster [-d disk] [-c cno] [-s size] [-m] [-r] [-q] [-x] or buildmaster -v </td></tr>
<tr>
<td>dataserver</td>
<td>dataserver - The executable form of the Adaptive Server program. dataserver -ddevicename [-cconfigurationfile] [-eerrorlogfile] [-m] [-rmastermirror] [-Msharedmem_directory] [-iinterfaces_file_directory] [-sservername] [-psso_login_name] or dataserver -v </td></tr>
<tr>
<td>defncopy</td>
<td>defncopy - Copies definitions for specified views, rules, defaults, triggers, or procedures from a database to an operating system file or from an operating system file to a database. The defncopy utility cannot copy table definitions or reports created with Report Workbench. defncopy [-X] [-a display_charset] [-I interfaces_file] [-J ] [-P password] [-R remote_server_principal] [-S ] [-U username] [-z language] {in filename dbname | out filename dbname objectname [objectname...] } or defncopy -v </td></tr>
<tr>
<td>dscp</td>
<td>dscp - Allows you to view and edit server entries in the interfaces file from the command line. dscp [-p] or dscp -v To exit from dscp: quit or exit </td></tr>
<tr>
<td>dsedit</td>
<td>dsedit - Allows you to view and edit server entries in the interfaces file using a graphical user interface based on X11/Motif. dsedit or dsedit -v </td></tr>
<tr>
<td>isql</td>
<td>isql - Interactive SQL parser to Adaptive Server. isql [-b] [-e] [-F] [-n] [-p] [-X] [-Y] [-a display_charset] [-A size] [-c cmdend] [-D database] [-E editor] [-h headers] [-H hostname] [-i inputfile] [-I interfaces_file] [-J client_charset] [-l login_timeout] [-m errorlevel] [-o outputfile] [-P password] [-R remote_server_principal] [-s colseparator] [-S server] [-t timeout] [-U username] [-w columnwidth] [-z language] or isql -v To terminate a command: go To clear the query buffer: reset To call the default editor: vi To execute an operating system command: !! command To exit from isql: quit or exit </td></tr>
<tr>
<td>langinstall</td>
<td>langinstall - Installs a new language in an Adaptive Server. langinstall [-S server] [-I interfaces_file] [-P password] [-R release_number] language character_set or langinstall -v </td></tr>
<tr>
<td>optdiag</td>
<td>optdiag - Displays optimizer statistics or loads updated statistics into system tables. optdiag [ binary ] statistics { -i input_file | database[.owner[.]]] [-o output_file] } [-U username] [-P password] [-I interfaces_file] [-S server] [-v] [-h] [-Tflag_value] [-z language] [-J client_charset] [-a display_charset] </td></tr>
<tr>
<td>showserver</td>
<td>showserver - Shows the Adaptive Servers and Backup Servers that are currently running on the local machine. showserver </td></tr>
<tr>
<td>sqlloc</td>
<td>sqlloc - Installs and modifies languages, character sets, and sort order defaults for Adaptive Server using a graphical user interface based on X11/Motif. sqlloc [-S server] [-U user] [-P password] [-s sybase_dir] [-I interfaces_file] [-r resource_file] or sqlloc -v </td></tr>
<tr>
<td>sqllocres</td>
<td>sqllocres - Installs and modifies languages, character sets, and sort order defaults for Adaptive Server, using a resource file. sqllocres [-S server] [-U user] [-P password] [-s sybase_dir] [-I interfaces_file] [-r resource_file] or sqllocres -v </td></tr>
<tr>
<td>sqlupgrade</td>
<td>sqlupgrade - Upgrades your currently installed release of Adaptive Server to the newest release using a graphical user interface based on X11/Motif. sqlupgrade [-s sybase_dir] [-r resource_file] or sqlupgrade -v </td></tr>
<tr>
<td>sqlupgraderes</td>
<td>sqlupgraderes - Upgrades your currently installed release of Adaptive Server to the newest release using resource files. sqlupgraderes [-s sybase_dir] [-r resource_file] or sqlupgraderes -v </td></tr>
<tr NOSAVE="NOSAVE" >
<td NOSAVE="NOSAVE" >srvbuild</td>
<td>srvbuild - Creates a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes using a graphical user interface based on X11/Motif. srvbuild [-s sybase_dir] [-I interfaces_file] [-r resource_file] or srvbuild -v </td></tr>
<tr>
<td>srvbuildres</td>
<td>srvbuildres - Creates, using resource files, a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes. srvbuildres [-s sybase_dir] [-I interfaces_file] [-r resource_file] or srvbuildres -v </td></tr>
<tr>
<td>startserver</td>
<td>startserver - Starts an Adaptive Server and/or a Backup Server. startserver [[-f runserverfile] [-m]] ... </td></tr>
<tr>
<td>sybload</td>
<td>sybload - Uploads Sybase products from the distribution media and builds the Sybase installation directory. sybload [-D] </td></tr>
<tr>
<td>sybsetup</td>
<td>sybsetup - Installs and configures Adaptive Server from a single location using a graphical user interface based on X11/Motif. sybsetup [-c devicename] [-t devicename] [-l local_source] [-r remote_source] </td></tr></tbody></table>

ehxz 发表于 2008-2-21 10:18:42

<center>
<h1>Quick Reference Guide for ASE</h1></center>
   
System Stored Procs  
<table border="1" NOSAVE="NOSAVE" >
<tbody>
<tr>
<td>sp_activeroles</td>
<td>sp_activeroles - Displays all active roles. sp_activeroles  </td></tr>
<tr>
<td>sp_add_resource_limit</td>
<td>sp_add_resource_limit - Creates a limit on the number of server resources that can be used by an Adaptive Server login and/or an application to execute a query, query batch, or transaction. sp_add_resource_limit name, appname, rangename, limittype, limitvalue [, enforced [, action [, scope ]]] </td></tr>
<tr>
<td>sp_add_time_range</td>
<td>sp_add_time_range - Adds a named time range to an Adaptive Server. sp_add_time_range name, startday, endday, starttime, endtime </td></tr>
<tr NOSAVE="NOSAVE" >
<td NOSAVE="NOSAVE" >sp_addalias</td>
<td>sp_addalias - Allows an Adaptive Server user to be known in a database as another user. sp_addalias loginame, name_in_db </td></tr>
<tr>
<td>sp_addauditrecord</td>
<td>sp_addauditrecord - Allows users to enter user-defined audit records (comments) into the audit trail. sp_addauditrecord [, db_name] [, obj_name] [, owner_name] [, dbid] [, objid] </td></tr>
<tr>
<td>sp_addaudittable</td>
<td>sp_addaudittable - Adds another system audit table after auditing is installed. sp_addaudittable devname </td></tr>
<tr>
<td>sp_addengine</td>
<td>sp_addengine - Adds an engine to an existing engine group or, if the group does not exist, creates an engine group and adds the engine. sp_addengine engine_number, engine_group </td></tr>
<tr>
<td>sp_addexeclass</td>
<td>sp_addexeclass - Creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures. sp_addexeclass classname, priority, timeslice, engine_group </td></tr>
<tr>
<td>sp_addextendedproc</td>
<td>sp_addextendedproc - Creates an extended stored procedure (ESP) in the master database. sp_addextendedproc esp_name, dll_name </td></tr>
<tr>
<td>sp_addexternlogin</td>
<td>sp_addexternlogin - Creates an alternate login account and password to use when communicating with a remote server through Component Integration Services. sp_addexternlogin server, loginname, externname [, externpassword] </td></tr>
<tr>
<td>sp_addgroup</td>
<td>sp_addgroup - Adds a group to a database. Groups are used as collective names in granting and revoking privileges. sp_addgroup grpname </td></tr>
<tr>
<td>sp_addlanguage</td>
<td>sp_addlanguage - Defines the names of the months and days for an alternate language and its date format. sp_addlanguage language, alias, months, shortmons, days, datefmt, datefirst </td></tr>
<tr>
<td>sp_addlogin</td>
<td>sp_addlogin - Adds a new user account to Adaptive Server. sp_addlogin loginame, passwd [, defdb [, deflanguage [, fullname]]] </td></tr>
<tr>
<td>sp_addmessage</td>
<td>sp_addmessage - Adds user-defined messages to sysusermessages for use by stored procedure print and raiserror calls and by sp_bindmsg. sp_addmessage message_num, message_text [, language] [, with_log] [, replace] </td></tr>
<tr>
<td>sp_addobjectdef</td>
<td>sp_addobjectdef - Specifies the mapping between a local table and an external storage location. sp_addobjectdef tablename, "objectdef" [,"objecttype"] </td></tr>
<tr>
<td>sp_addremotelogin</td>
<td>sp_addremotelogin - Authorizes a new remote server user by adding an entry to master.dbo.sysremotelogins. sp_addremotelogin remoteserver [, loginame [, remotename] ] </td></tr>
<tr>
<td>sp_addsegment</td>
<td>sp_addsegment - Defines a segment on a database device in a database. sp_addsegment segname, dbname, devname </td></tr>
<tr>
<td>sp_addserver</td>
<td>sp_addserver - Defines a remote server, or defines the name of the local server. sp_addserver lname [, class [, pname]] </td></tr>
<tr>
<td>sp_addthreshold</td>
<td>sp_addthreshold - Creates a threshold to monitor space on a database segment. When free space on the segment falls below the specified level, Adaptive Server executes the associated stored procedure. sp_addthreshold dbname, segname, free_space, proc_name </td></tr>
<tr>
<td>sp_addtype</td>
<td>sp_addtype - Creates a user-defined datatype. sp_addtype typename, phystype [(length) | (precision [, scale])] [, "identity" | nulltype] </td></tr>
<tr>
<td>sp_addumpdevice</td>
<td>sp_addumpdevice - Adds a dump device to Adaptive Server. sp_addumpdevice {"tape" | "disk"}, logicalname, physicalname [, tapesize] </td></tr>
<tr>
<td>sp_adduser</td>
<td>sp_adduser - Adds a new user to the current database. sp_adduser loginame [, name_in_db [, grpname]] </td></tr>
<tr>
<td>sp_altermessage</td>
<td>sp_altermessage - Enables and disables the logging of a system-defined or user-defined message in the Adaptive Server error log. sp_altermessage message_id, parameter, parameter_value </td></tr>
<tr>
<td>sp_audit</td>
<td>sp_audit - Allows a System Security Officer to configure auditing options. sp_audit option, login_name, object_name [,setting] </td></tr>
<tr>
<td>sp_autoconnect</td>
<td>sp_autoconnect - Defines a passthrough connection to a remote server for a specific user, which allows the named user to enter passthrough mode automatically at login. sp_autoconnect server, {true|false} [, loginame] </td></tr>
<tr>
<td>sp_bindcache</td>
<td>sp_bindcache - Binds a database, table, index, text object, or image object to a data cache. sp_bindcache cachename, dbname [, tablename [, indexname | "text only"]] </td></tr>
<tr>
<td>sp_bindefault</td>
<td>sp_bindefault - Binds a user-defined default to a column or user-defined datatype. sp_bindefault defname, objname [, futureonly] </td></tr>
<tr>
<td>sp_bindexeclass</td>
<td>sp_bindexeclass - Associates an execution class with a client application, login, or stored procedure. sp_bindexeclass "object_name", "object_type", "scope", "classname" </td></tr>
<tr>
<td>sp_bindmsg</td>
<td>sp_bindmsg - Binds a user message to a referential integrity constraint or check constraint. sp_bindmsg constrname, msgid </td></tr>
<tr>
<td>sp_bindrule</td>
<td>sp_bindrule - Binds a rule to a column or user-defined datatype. sp_bindrule rulename, objname [, futureonly] </td></tr>
<tr>
<td>sp_cacheconfig</td>
<td>sp_cacheconfig - Creates, configures, reconfigures, and drops data caches, and provides information about them. sp_cacheconfig " ] [,logonly | mixed ] [,strict | relaxed ] ] </td></tr>
<tr>
<td>sp_cachestrategy</td>
<td>sp_cachestrategy - Enables or disables prefetching (large I/O) and MRU cache replacement strategy for a table, index, text object, or image object. sp_cachestrategy dbname, tablename [, indexname | "text only" | "table only" [, { prefetch | mru }, { "on" | "off"}]] </td></tr>
<tr>
<td>sp_changedbowner</td>
<td>sp_changedbowner - Changes the owner of a user database. sp_changedbowner loginame [, true ] </td></tr>
<tr>
<td>sp_changegroup</td>
<td>sp_changegroup - Changes a user's group. sp_changegroup grpname, username </td></tr>
<tr>
<td>sp_checknames</td>
<td>sp_checknames - Checks the current database for names that contain characters not in the 7-bit ASCII set. sp_checknames </td></tr>
<tr>
<td>sp_checkreswords</td>
<td>sp_checkreswords - Detects and displays identifiers that are Transact-SQL reserved words. Checks server names, device names, database names, segment names, user-defined datatypes, object names, column names, user names, login names, and remote login names. sp_checkreswords  </td></tr>
<tr>
<td>sp_checksource</td>
<td>sp_checksource - Checks for the existence of the source text of the compiled object. sp_checksource ]] </td></tr>
<tr>
<td>sp_chgattribute</td>
<td>space allocations of a table or an index. Sets the concurrency_opt_threshold for a table. concurrency_opt_threshold }, optvalue </td></tr>
<tr>
<td>sp_clearpsexe</td>
<td>sp_clearpsexe - Clears the execution attributes of an Adaptive Server session that was set by sp_setpsexe. sp_clearpsexe spid, exeattr </td></tr>
<tr>
<td>sp_clearstats</td>
<td>sp_clearstats - Initiates a new accounting period for all server users or for a specified user. Prints statistics for the previous period by executing sp_reportstats. sp_clearstats  </td></tr>
<tr>
<td>sp_column_privileges</td>
<td>sp_column_privileges - Returns permissions information for one or more columns in a table or view. sp_column_privileges table_name [, table_owner [, table_qualifier [, column_name]]] </td></tr>
<tr>
<td>sp_columns</td>
<td>sp_columns - Returns information about the type of data that can be stored in one or more columns. sp_columns table_name [, table_owner ] [, table_qualifier] [, column_name] </td></tr>
<tr>
<td>sp_commonkey</td>
<td>sp_commonkey - Defines a common key-columns that are frequently joined-between two tables or views. sp_commonkey tabaname, tabbname, col1a, col1b [, col2a, col2b, ..., col8a, col8b] </td></tr>
<tr>
<td>sp_configure</td>
<td>sp_configure - Displays or changes configuration parameters. sp_configure | group_name | non_unique_parameter_fragment] sp_configure "configuration file", 0, {"write" | "read" | "verify" | "restore"} "file_name" </td></tr>
<tr>
<td>sp_countmetadata</td>
<td>sp_countmetadata - Displays the number of indexes, objects, or databases in Adaptive Server. sp_countmetadata "configname" [, dbname] </td></tr>
<tr>
<td>sp_cursorinfo</td>
<td>sp_cursorinfo - Reports information about a specific cursor or all cursors that are active for your session. sp_cursorinfo [{cursor_level | null}] [, cursor_name] </td></tr>
<tr>
<td>sp_databases</td>
<td>sp_databases - Returns a list of databases in Adaptive Server. sp_databases </td></tr>
<tr>
<td>sp_datatype_info</td>
<td>sp_datatype_info - Returns information about a particular ODBC datatype or about all ODBC datatypes. sp_datatype_info  </td></tr>
<tr>
<td>sp_dboption</td>
<td>sp_dboption - Displays or changes database options. sp_dboption  </td></tr>
<tr>
<td>sp_dbrecovery_order</td>
<td>sp_dbrecovery_order - Specifies the order in which individual user databases are recovered and lists the user-defined recovery order of an individual database or all databases. sp_dbrecovery_order ]] </td></tr>
<tr>
<td>sp_dbremap</td>
<td>sp_dbremap - Forces Adaptive Server to recognize changes made by alter database. Run this procedure only when instructed to do so by an Adaptive Server message. sp_dbremap dbname </td></tr>
<tr>
<td>sp_defaultloc</td>
<td>sp_defaultloc - Defines a default storage location for objects in a local database. sp_defaultloc dbname, {"defaultloc"| NULL} [, "defaulttype"] </td></tr>
<tr>
<td>sp_depends</td>
<td>sp_depends - Displays information about database object dependencies-the view(s), trigger(s), and procedure(s) in the database that depend on a specified table or view, and the table(s) and view(s) in the database on which the specified view, trigger, or procedure depends. sp_depends objname </td></tr>
<tr>
<td>sp_diskdefault</td>
<td>sp_diskdefault - Specifies whether or not a database device can be used for database storage if the user does not specify a database device or specifies default with the create database or alter database commands. sp_diskdefault logicalname, {defaulton | defaultoff} </td></tr>
<tr>
<td>sp_displayaudit</td>
<td>sp_displayaudit - Displays the active audit options. sp_displayaudit ] </td></tr>
<tr>
<td>sp_displaylevel</td>
<td>sp_displaylevel - Sets or shows which Adaptive Server configuration parameters appear in sp_configure output. sp_displaylevel ] </td></tr>
<tr>
<td>sp_displaylogin</td>
<td>sp_displaylogin - Displays information about a login account. Also displays information about the hierarchy tree above or below the login account when you so specify. sp_displaylogin ] </td></tr>
<tr>
<td>sp_displayroles</td>
<td>sp_displayroles - Displays all roles granted to another role, or displays the entire hierarchy tree of roles in table format. sp_displayroles {login_name | rolename [, expand_up | expand_down]} </td></tr>
<tr>
<td>sp_drop_resource_limit</td>
<td>sp_drop_resource_limit - Removes one or more resource limits from Adaptive Server. sp_drop_resource_limit {name, appname } [, rangename, limittype, enforced, action, scope] </td></tr>
<tr>
<td>sp_drop_time_range</td>
<td>sp_drop_time_range - Removes a user-defined time range from Adaptive Server. sp_drop_time_range name </td></tr>
<tr>
<td>sp_dropalias</td>
<td>sp_dropalias - Removes the alias user name identity established with sp_addalias. sp_dropalias loginame </td></tr>
<tr>
<td>sp_dropdevice</td>
<td>sp_dropdevice - Drops an Adaptive Server database device or dump device. sp_dropdevice logicalname </td></tr>
<tr>
<td>sp_dropengine</td>
<td>sp_dropengine - Drops an engine from a specified engine group or, if the engine is the last one in the group, drops the engine group. sp_dropengine engine_number, engine_group </td></tr>
<tr>
<td>sp_dropexeclass</td>
<td>sp_dropexeclass - Drops a user-defined execution class. sp_dropexeclass classname </td></tr>
<tr>
<td>sp_dropextendedproc</td>
<td>sp_dropextendedproc - Removes an extended stored procedure (ESP). sp_dropextendedproc esp_name </td></tr>
<tr>
<td>sp_dropexternlogin</td>
<td>sp_dropexternlogin - Drops the definition of a remote login previously defined by sp_addexternlogin. sp_dropexternlogin remote_server [, login_name] </td></tr>
<tr>
<td>sp_dropglockpromote</td>
<td>sp_dropglockpromote - Removes lock promotion values from a table or database. sp_dropglockpromote {"database" | "table"}, objname </td></tr>
<tr>
<td>sp_dropgroup</td>
<td>sp_dropgroup - Drops a group from a database. sp_dropgroup grpname </td></tr>
<tr>
<td>sp_dropkey</td>
<td>sp_dropkey - Removes from the syskeys table a key that had been defined using sp_primarykey, sp_foreignkey, or sp_commonkey. sp_dropkey keytype, tabname [, deptabname] </td></tr>
<tr>
<td>sp_droplanguage</td>
<td>sp_droplanguage - Drops an alternate language from the server and sp_droplanguage language [, dropmessages] </td></tr>
<tr>
<td>sp_droplogin</td>
<td>sp_droplogin - Drops an Adaptive Server user login by deleting the user's entry from master.dbo.syslogins. sp_droplogin loginame </td></tr>
<tr>
<td>sp_dropmessage</td>
<td>sp_dropmessage - Drops user-defined messages from sysusermessages. sp_dropmessage message_num [, language] </td></tr>
<tr>
<td>sp_dropobjectdef</td>
<td>sp_dropobjectdef - Deletes the external storage mapping provided for a local object. sp_dropobjectdef "object_name" </td></tr>
<tr>
<td>sp_dropremotelogin</td>
<td>sp_dropremotelogin - Drops a remote user login. sp_dropremotelogin remoteserver [, loginame [, remotename] ] </td></tr>
<tr>
<td>sp_droprowlockpromote</td>
<td>a database or table. </td></tr>
<tr>
<td>sp_dropsegment</td>
<td>sp_dropsegment - Drops a segment from a database or unmaps a segment from a particular database device. sp_dropsegment segname, dbname [, device] </td></tr>
<tr>
<td>sp_dropserver</td>
<td>sp_dropserver - Drops a server from the list of known servers or drops remote logins and external logins in the same operation. sp_dropserver server [, droplogins] </td></tr>
<tr>
<td>sp_dropthreshold</td>
<td>sp_dropthreshold - Removes a free-space threshold from a segment. sp_dropthreshold dbname, segname, free_space </td></tr>
<tr>
<td>sp_droptype</td>
<td>sp_droptype - Drops a user-defined datatype. sp_droptype typename </td></tr>
<tr>
<td>sp_dropuser</td>
<td>sp_dropuser - Drops a user from the current database. sp_dropuser name_in_db </td></tr>
<tr>
<td>sp_estspace</td>
<td>sp_estspace - Estimates the amount of space required for a table and its indexes, and the time needed to create the index. [, cols_to_max [, textbin_len [, iosec]]]] </td></tr>
<tr>
<td>sp_extendsegment</td>
<td>sp_extendsegment - Extends the range of a segment to another database device. sp_extendsegment segname, dbname, devname </td></tr>
<tr>
<td>sp_familylock</td>
<td>sp_familylock - Reports information about all the locks held by a family (coordinating process and its worker processes) executing a statement in parallel. sp_familylock ] </td></tr>
<tr>
<td>sp_fkeys</td>
<td>sp_fkeys - Returns information about foreign key constraints created with the create table or alter table command in the current database. sp_fkeys pktable_name [, pktable_owner] [, pktable_qualifier] [, fktable_name] [, fktable_owner] [, fktable_qualifier] </td></tr>
<tr>
<td>sp_flushstats</td>
<td>sp_flushstats - Flushes statistics from in-memory storage to the systabstats system table. sp_flushstats objname </td></tr>
<tr>
<td>sp_forceonline_db</td>
<td>sp_forceonline_db - Provides access to all the pages in a database that were previously marked suspect by recovery. sp_forceonline_page dbname, {"sa_on" | "sa_off" | "all_users"} </td></tr>
<tr>
<td>sp_forceonline_object</td>
<td>sp_forceonline_object - Provides access to an index previously marked suspect by recovery. sp_forceonline_object dbname, objname, indid, {sa_on | sa_off | all_users} [, no_print] </td></tr>
<tr>
<td>sp_forceonline_page</td>
<td>sp_forceonline_page - Provides access to pages previously marked suspect by recovery. sp_forceonline_page dbname, pgid, {"sa_on" | "sa_off" | "all_users"} </td></tr>
<tr>
<td>sp_foreignkey</td>
<td>sp_foreignkey - Defines a foreign key on a table or view in the current database. sp_foreignkey tabname, pktabname, col1 [, col2] ... [, col8] </td></tr>
<tr>
<td>sp_freedll</td>
<td>sp_freedll - Unloads a dynamic link library (DLL) that was previously loaded into XP Server memory to support the execution of an extended stored procedure (ESP). sp_freedll dll_name </td></tr>
<tr>
<td>sp_getmessage</td>
<td>sp_getmessage - Retrieves stored message strings from sysmessages and sysusermessages for print and raiserror statements. sp_getmessage message_num, result output [, language] </td></tr>
<tr>
<td>sp_grantlogin</td>
<td>sp_grantlogin - Assigns Adaptive Server roles or default permissions to Windows NT users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active. sp_grantlogin {login_name | group_name} ["role_list" | default] </td></tr>
<tr>
<td>sp_help</td>
<td>for tables. sp_help table_name </td></tr>
<tr>
<td>sp_help_resource_limit</td>
<td>sp_help_resource_limit - Reports on resource limits. sp_help_resource_limit ]]]]] </td></tr>
<tr>
<td>sp_helpartition</td>
<td>sp_helpartition - Lists the partition number, first page, control page, and number of data pages and summary size information for each partition in a partitioned table. sp_helpartition  </td></tr>
<tr>
<td>sp_helpcache</td>
<td>sp_helpcache - Displays information about the objects that are bound to a data cache or the amount of overhead required for a specified cache size. sp_helpcache {cache_name | "cache_size"} </td></tr>
<tr>
<td>sp_helpconfig</td>
<td>sp_helpconfig - Reports help information on configuration parameters. sp_helpconfig "configname", ["size"] </td></tr>
<tr>
<td>sp_helpconstraint</td>
<td>sp_helpconstraint - Reports information about integrity constraints used in the specified tables. sp_helpconstraint [, detail] </td></tr>
<tr>
<td>sp_helpdb</td>
<td>database. sp_helpdb  </td></tr>
<tr>
<td>sp_helpdevice</td>
<td>sp_helpdevice - Reports information about a particular device or about all Adaptive Server database devices and dump devices. sp_helpdevice  </td></tr>
<tr>
<td>sp_helpextendedproc</td>
<td>sp_helpextendedproc - Displays extended stored procedures (ESPs) in the current database, along with their associated DLL files. sp_helpextendedproc  </td></tr>
<tr>
<td>sp_helpexternlogin</td>
<td>sp_helpexternlogin - Reports information about external login names. sp_helpexternlogin ] </td></tr>
<tr>
<td>sp_helpgroup</td>
<td>sp_helpgroup - Reports information about a particular group or about all groups in the current database. sp_helpgroup  </td></tr>
<tr>
<td>sp_helpindex</td>
<td>sp_helpindex - Reports new information about the indexes created on a table. sp_helpindex objname </td></tr>
<tr>
<td>sp_helpjoins</td>
<td>sp_helpjoins - Lists the columns in two tables or views that are likely join candidates. sp_helpjoins lefttab, righttab </td></tr>
<tr>
<td>sp_helpkey</td>
<td>sp_helpkey - Reports information about a primary, foreign, or common key of a particular table or view, or about all keys in the current database. sp_helpkey  </td></tr>
<tr>
<td>sp_helplanguage</td>
<td>sp_helplanguage - Reports information about a particular alternate language or about all languages. sp_helplanguage  </td></tr>
<tr>
<td>sp_helplog</td>
<td>sp_helplog - Reports the name of the device that contains the first page of the transaction log. sp_helplog </td></tr>
<tr>
<td>sp_helpobjectdef</td>
<td>sp_helpobjectdef - Reports owners, objects, and type information for remote object definitions. sp_helpobjectdef  </td></tr>
<tr>
<td>sp_helpremotelogin</td>
<td>sp_helpremotelogin - Reports information about a particular remote server's logins or about all remote server logins. sp_helpremotelogin ] </td></tr>
<tr>
<td>sp_helprotect</td>
<td>sp_helprotect - Reports on permissions for database objects, users, groups, or roles. sp_helprotect ]]] </td></tr>
<tr>
<td>sp_helpsegment</td>
<td>sp_helpsegment - Reports information about a particular segment or about all segments in the current database. sp_helpsegment  </td></tr>
<tr>
<td>sp_helpserver</td>
<td>sp_helpserver - Reports information about a particular remote server or about all remote servers. sp_helpserver  </td></tr>
<tr>
<td>sp_helpsort</td>
<td>sp_helpsort - Displays Adaptive Server's default sort order and character set. sp_helpsort </td></tr>
<tr>
<td>sp_helptext</td>
<td>sp_helptext - Displays the source text of a compiled object. sp_helptext objname </td></tr>
<tr>
<td>sp_helpthreshold</td>
<td>sp_helpthreshold - Reports the segment, free-space value, status, and stored procedure associated with all thresholds in the current database or all thresholds for a particular segment. sp_helpthreshold  </td></tr>
<tr>
<td>sp_helpuser</td>
<td>sp_helpuser - Reports information about a particular user, group, or alias, or about all users, in the current database. sp_helpuser  </td></tr>
<tr>
<td>sp_hidetext</td>
<td>sp_hidetext - Hides the source text for the specified compiled object. sp_hidetext ]] </td></tr>
<tr>
<td>sp_indsuspect</td>
<td>sp_indsuspect - Checks user tables for indexes marked as suspect during recovery following a sort order change. sp_indsuspect  </td></tr>
<tr>
<td>sp_listsuspect_db</td>
<td>sp_listsuspect_db - Lists all databases that currently have offline pages because of corruption detected on recovery. sp_listsuspect_db </td></tr>
<tr>
<td>sp_listsuspect_object</td>
<td>sp_listsuspect_object - Lists all indexes in a database that are currently offline because of corruption detected on recovery. sp_listsuspect_object  </td></tr>
<tr>
<td>sp_listsuspect_page</td>
<td>sp_listsuspect_page - Lists all pages in a database that are currently offline because of corruption detected on recovery. sp_listsuspect_page  </td></tr>
<tr>
<td>sp_lock</td>
<td>sp_lock - Reports additional information about processes that currently hold locks. sp_lock ] </td></tr>
<tr>
<td>sp_locklogin</td>
<td>sp_locklogin - Locks an Adaptive Server account so that the user cannot log in or displays a list of all locked accounts. sp_locklogin  </td></tr>
<tr>
<td>sp_logdevice</td>
<td>sp_logdevice - Moves the transaction log of a database with log and data on the same device to a separate database device. sp_logdevice dbname, devname </td></tr>
<tr>
<td>sp_loginconfig</td>
<td>sp_loginconfig - Displays the value of one or all integrated security parameters. sp_loginconfig ["parameter_name"] </td></tr>
<tr>
<td>sp_logininfo</td>
<td>sp_logininfo - Displays all roles granted to Windows NT users and groups with sp_grantlogin. sp_logininfo ["login_name" | "group_name"] </td></tr>
<tr>
<td>sp_logiosize</td>
<td>sp_logiosize - Changes the log I/O size used by Adaptive Server to a different memory pool when doing I/O for the transaction log of the current database. sp_logiosize ["default" | "size" | "all"] </td></tr>
<tr>
<td>sp_modify_resource_limit</td>
<td>sp_modify_resource_limit - Changes a resource limit by specifying a new limit value or the action to take when the limit is exceeded, or both. sp_modify_resource_limit {name, appname } , rangename, limittype [, limitvalue] [, enforced] [, action] [, scope] </td></tr>
<tr>
<td>sp_modify_time_range</td>
<td>sp_modify_time_range - Changes the start day, start time, end day, and/or end time associated with a named time range. sp_modify_time_range name, startday, endday, starttime, endtime </td></tr>
<tr>
<td>sp_modifylogin</td>
<td>sp_modifylogin - Modifies the default database, default language, default role activation, or full name for a Adaptive Server login account. sp_modifylogin account, column, value </td></tr>
<tr>
<td>sp_modifythreshold</td>
<td>sp_modifythreshold - Modifies a threshold by associating it with a different threshold procedure, free-space level, or segment name. You cannot use sp_modifythreshold to change the amount of free space or the segment name for the last-chance threshold. sp_modifythreshold dbname, segname, free_space [, new_proc_name] [, new_free_space] [, new_segname] </td></tr>
<tr>
<td>sp_monitor</td>
<td>sp_monitor - Displays statistics about Adaptive Server. sp_monitor </td></tr>
<tr>
<td>sp_monitorconfig</td>
<td>sp_monitorconfig - Displays cache usage statistics regarding metadata descriptors for indexes, objects, and databases. sp_monitorconfig also reports statistics on auxiliary scan descriptors used for referential integrity queries. sp_monitorconfig "configname" </td></tr>
<tr>
<td>sp_object_stats</td>
<td>sp_object_stats - Prints lock statistics for tables and indexes. sp_object_stats interval [, top_n [, dbname, objname [, rpt_option ]]] </td></tr>
<tr>
<td>sp_passthru</td>
<td>sp_passthru - Allows the user to pass a SQL command buffer to a remote server. [, arg1, arg2, ... argn] </td></tr>
<tr>
<td>sp_password</td>
<td>sp_password - Adds or changes a password for an Adaptive Server login account. sp_password caller_passwd, new_passwd [, loginame] </td></tr>
<tr>
<td>sp_pkeys</td>
<td>sp_pkeys - Returns information about primary key constraints created with the create table or alter table command for a single table. sp_pkeys table_name [, table_owner] [, table_qualifier] </td></tr>
<tr>
<td>sp_placeobject</td>
<td>sp_placeobject - Puts future space allocations for a table or index on a particular segment. sp_placeobject segname, objname </td></tr>
<tr>
<td>sp_plan_dbccdb</td>
<td>sp_plan_dbccdb - Recommends suitable sizes for new dbccdb and dbccalt databases, lists suitable devices for dbccdb and dbccalt, and suggests a cache size and a suitable number of worker processes for the target database. sp_plan_dbccdb  </td></tr>
<tr>
<td>sp_poolconfig</td>
<td>sp_poolconfig - Creates, drops, resizes, and provides information about memory pools within data caches. To create a memory pool in an existing cache, or to change pool size: sp_poolconfig cache_name [, "mem_size", "config_poolK" [, "affected_poolK"]] To change a pool's wash size: sp_poolconfig cache_name, "io_size", "wash=size" To change a pool's asynchronous prefetch percentage: sp_poolconfig cache_name, "io_size", "local async prefetch limit=percent" </td></tr>
<tr>
<td>sp_primarykey</td>
<td>sp_primarykey - Defines a primary key on a table or view. sp_primarykey tabname, col1 [, col2, col3, ..., col8] </td></tr>
<tr>
<td>sp_processmail</td>
<td>sp_processmail - Reads, processes, sends, and deletes messages in the Adaptive Server message inbox, using the xp_findnextmsg, xp_readmail, xp_sendmail, and xp_deletemail system extended stired procedures (ESPs). sp_processmail [, originator [, dbuser [, dbname [, filetype [, separator]]]]] </td></tr>
<tr>
<td>sp_procqmode</td>
<td>sp_procqmode - Displays the query processing mode of a stored procedure, view, or trigger. sp_procqmode ] </td></tr>
<tr>
<td>sp_procxmode</td>
<td>sp_procxmode - Displays or changes the transaction modes associated with stored procedures. sp_procxmode ] </td></tr>
<tr>
<td>sp_recompile</td>
<td>sp_recompile - Causes each stored procedure and trigger that uses the named table to be recompiled the next time it runs. sp_recompile objname </td></tr>
<tr>
<td>sp_remap</td>
<td>sp_remap - Remaps a stored procedure, trigger, rule, default, or view from releases later than 4.8 and prior to 10.0 to be compatible with releases 10.0 and later. Use sp_remap on pre-existing objects that the upgrade procedure failed to remap. sp_remap objname </td></tr>
<tr>
<td>sp_remoteoption</td>
<td>sp_remoteoption - Displays or changes remote login options. sp_remoteoption ]]]] </td></tr>
<tr>
<td>sp_remotesql</td>
<td>sp_remotesql - Establishes a connection to a remote server, passes a query buffer to the remote server from the client, and relays the results back to the client. sp_remotesql server, query [, query2, ... , query254] </td></tr>
<tr>
<td>sp_rename</td>
<td>sp_rename - Changes the name of a user-created object or user-defined datatype in the current database. sp_rename objname, newname </td></tr>
<tr>
<td>sp_renamedb</td>
<td>sp_renamedb - Changes the name of a user database. sp_renamedb dbname, newname </td></tr>
<tr>
<td>sp_reportstats</td>
<td>sp_reportstats - Reports statistics on system usage. sp_reportstats  </td></tr>
<tr>
<td>sp_revokelogin</td>
<td>sp_revokelogin - Revokes Adaptive Server roles and default permissions from Windows NT users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active. sp_revokelogin {login_name | group_name} </td></tr>
<tr>
<td>sp_role</td>
<td>sp_role - Grants or revokes system roles to an Adaptive Server login account. sp_role {"grant" | "revoke"}, {sa_role | sso_role | oper_role}, loginame </td></tr>
<tr>
<td>sp_server_info</td>
<td>sp_server_info - Returns a list of Adaptive Server attribute names and current values. sp_server_info  </td></tr>
<tr>
<td>sp_serveroption</td>
<td>sp_serveroption - Displays or changes remote server options. sp_serveroption  </td></tr>
<tr>
<td>sp_setlangalias</td>
<td>sp_setlangalias - Assigns or changes the alias for an alternate language. sp_setlangalias language, alias </td></tr>
<tr>
<td>sp_setpglockpromote</td>
<td>sp_setpglockpromote - Sets or changes the lock promotion thresholds for a database, for a table, or for Adaptive Server. sp_setpglockpromote {"database" | "table"}, objname, new_lwm, new_hwm, new_pct sp_setpglockpromote server, NULL, new_lwm, new_hwm, new_pct </td></tr>
<tr>
<td>sp_setpsexe</td>
<td>sp_setpsexe - Sets custom execution attributes "on the fly" for a session. sp_setpsexe spid, exeattr, value </td></tr>
<tr>
<td>sp_setrowlockpromote</td>
<td>tables on a server. new_hwm, new_pct new_lwm, new_hwm, new_pct </td></tr>
<tr>
<td>sp_setsuspect_granularity</td>
<td>sp_setsuspect_granularity - Displays or sets the recovery fault isolation mode for a user database, which governs how recovery behaves when it detects data corruption. sp_setsuspect_granularity ]] </td></tr>
<tr>
<td>sp_setsuspect_threshold</td>
<td>sp_setsuspect_threshold - Displays or sets the maximum number of suspect pages that Adaptive Server allows in a database before marking the entire database suspect. sp_setsuspect_threshold ] </td></tr>
<tr>
<td>sp_showcontrolinfo</td>
<td>sp_showcontrolinfo - Displays information about engine group assignments, bound client applications, logins, and stored procedures. sp_showcontrolinfo  </td></tr>
<tr>
<td>sp_showexeclass</td>
<td>sp_showexeclass - Displays the execution class attributes and the engines in any engine group associated with the specified execution class. sp_showexeclass  </td></tr>
<tr>
<td>sp_showplan</td>
<td>sp_showplan - Displays the showplan output for any user connection for the current SQL statement or for a previous statement in the same batch. sp_showplan spid, batch_id output, context_id output, stmt_num output To display the showplan output for the current SQL statement without specifying the batch_id, context_id, or stmt_num: sp_showplan spid, null, null, null </td></tr>
<tr>
<td>sp_showpsexe</td>
<td>sp_showpsexe - Displays execution class, current priority, and affinity for all client sessions running on Adaptive Server. sp_showpsexe  </td></tr>
<tr>
<td>sp_spaceused</td>
<td>number of data pages, the size of indexes, and the space used by a specified table or by all tables in the current database. sp_spaceused ] </td></tr>
<tr>
<td>sp_special_columns</td>
<td>sp_special_columns - Returns the optimal set of columns that uniquely return a list of timestamp columns, whose values are automatically generated when any value in the sp_special_columns table_name [, table_owner] [, table_qualifier] [, col_type] </td></tr>
<tr>
<td>sp_sproc_columns</td>
<td>sp_sproc_columns - Returns information about a stored procedure's input and return parameters. sp_sproc_columns procedure_name [, procedure_owner] [, procedure_qualifier] [, column_name] </td></tr>
<tr>
<td>sp_statistics</td>
<td>sp_statistics - Returns a list of indexes on a single table. sp_statistics table_name [, table_owner] [, table_qualifier] [, index_name] [, is_unique] </td></tr>
<tr>
<td>sp_stored_procedures</td>
<td>sp_stored_procedures - Returns information about one or more stored procedures. sp_stored_procedures ]] </td></tr>
<tr>
<td>sp_syntax</td>
<td>system procedures, utilities, and other routines for Adaptive Server, depending on which products and corresponding sp_syntax scripts exist on your server. sp_syntax word [, mod][, language] </td></tr>
<tr>
<td>sp_sysmon</td>
<td>sp_sysmon - Displays performance information. sp_sysmon { begin_sample | end_sample | interval } [, section] </td></tr>
<tr>
<td>sp_table_privileges</td>
<td>sp_table_privileges - Returns privilege information for all columns in a table or view. sp_table_privileges table_name [, table_owner [, table_qualifier]] </td></tr>
<tr>
<td>sp_tables</td>
<td>sp_tables - Returns a list of objects that can appear in a from clause. sp_tables [, table_owner] [, table_qualifier][, table_type] </td></tr>
<tr>
<td>sp_thresholdaction</td>
<td>sp_thresholdaction - Executes automatically when the number of free pages on the log segment falls below the last-chance threshold, unless the threshold is associated with a different procedure. Sybase does not provide this procedure. When a threshold is crossed, Adaptive Server passes the following parameters to the threshold procedure by position: sp_thresholdaction @dbname, @segment_name, @space_left, @status </td></tr>
<tr>
<td>sp_unbindcache</td>
<td>sp_unbindcache - Unbinds a database, table, index, text object, or image object from a data cache. sp_unbindcache dbname [,tablename [, indexname | "text only"]] </td></tr>
<tr>
<td>sp_unbindcache_all</td>
<td>sp_unbindcache_all - Unbinds all objects that are bound to a cache. sp_unbindcache_all cache_name </td></tr>
<tr>
<td>sp_unbindefault</td>
<td>sp_unbindefault - Unbinds a created default value from a column or from a user-defined datatype. sp_unbindefault objname [, futureonly] </td></tr>
<tr>
<td>sp_unbindexeclass</td>
<td>sp_unbindexeclass - Removes the execution class attribute previously associated with an client application, login, or stored procedure for the specified scope. sp_unbindexeclass object_name, object_type, scope </td></tr>
<tr>
<td>sp_unbindmsg</td>
<td>sp_unbindmsg - Unbinds a user-defined message from a constraint. sp_unbindmsg constrname </td></tr>
<tr>
<td>sp_unbindrule</td>
<td>sp_unbindrule - Unbinds a rule from a column or from a user-defined datatype. sp_unbindrule objname [, futureonly] </td></tr>
<tr>
<td>sp_volchanged</td>
<td>sp_volchanged - Notifies the Backup Server that the operator performed the requested volume handling during a dump or load. sp_volchanged session_id, devname, action [, fname [, vname]] </td></tr>
<tr>
<td>sp_who</td>
<td>sp_who - Reports information about all current Adaptive Server users and processes or about a particular user or process. sp_who  </td></tr></tbody></table>

ehxz 发表于 2008-2-21 11:06:07

<center>
<h1>Quick Reference Guide for ASE</h1></center>
   
Transac SQL statments  
<table border="1" NOSAVE="NOSAVE" >
<tbody>
<tr>
<td>abs</td>
<td>abs - Returns the absolute value of an expression. abs(numeric_expression) </td></tr>
<tr>
<td>acos</td>
<td>acos - Returns the angle (in radians) whose cosine is specified. acos(cosine) </td></tr>
<tr NOSAVE="NOSAVE" >
<td NOSAVE="NOSAVE" >alter database</td>
<td>alter database - Increases the amount of space allocated to a database. alter database database_name [, database_device [= size]]...] [ , database_device [= size]]...]  </td></tr>
<tr>
<td>alter role</td>
<td>alter role - Defines mutually exclusive relationships between roles and adds, drops, and changes passwords for roles. alter role role1 { add | drop } exclusive { membership | activation } role2 alter role role_name { add passwd "password"| drop passwd } </td></tr>
<tr>
<td>alter table</td>
<td>alter table - Changes the locking scheme for an existing table; specifies ascending or descending index order when alter table is used to create referential integrity constraints that are based on indexes; specifies the ratio of filled pages to empty pages, to reduce storage fragmentation. alter table .]table_name { add column_name datatype {identity | null} [ { { unique | primary key } | references [owner.]ref_table [(ref_column)] | check (search_condition) ] ... } [, next_column]... | add { { {unique | primary key} (column_name [, column_name ...]) | foreign key (column_name [,column_name...]) references [owner.]ref_table [(ref_column [, ref_column...])] | check (search_condition)} } | drop constraint constraint_name | replace column_name default {constant_expression | user | null} | partition number_of_partitions | unpartition </td></tr>
<tr>
<td>ascii</td>
<td>ascii - Returns the ASCII code for the first character in an expression. ascii(char_expr) </td></tr>
<tr>
<td>asin</td>
<td>asin - Returns the angle (in radians) whose sine is specified. asin(sine) </td></tr>
<tr>
<td>atan</td>
<td>atan - Returns the angle (in radians) whose tangent is specified. atan(tangent) </td></tr>
<tr>
<td>atn2</td>
<td>atn2 - Returns the angle (in radians) whose sine and cosine are specified. atn2(sine, cosine) </td></tr>
<tr>
<td>avg</td>
<td>avg - Returns the numeric average of all (distinct) values. avg( expression) </td></tr>
<tr>
<td>begin transaction</td>
<td>begin transaction - Marks the starting point of a user-defined transaction. begin tran  </td></tr>
<tr>
<td>begin...end</td>
<td>begin...end - Encloses a series of SQL statements so that control-of-flow language, such as if...else, can affect the performance of the whole group. begin statement block end </td></tr>
<tr>
<td>break</td>
<td>break - Causes an exit from a while loop. break is often activated by an if test. while logical_expression statement break statement continue </td></tr>
<tr>
<td>case</td>
<td>case - Supports conditional SQL expressions. case expressions can be used anywhere a value expression can be used. case when search_condition then expression ... end case expression when expression then expression ... end coalesce(expression, expression [, expression]...) nullif(expression, expression) </td></tr>
<tr>
<td>ceiling</td>
<td>ceiling - Returns the smallest integer greater than or equal to the specified value. ceiling(value) </td></tr>
<tr>
<td>char</td>
<td>char - Returns the character equivalent of an integer. char(integer_expr) </td></tr>
<tr>
<td>char_length</td>
<td>char_length - Returns the number of characters in an expression. char_length(char_expr) </td></tr>
<tr>
<td>charindex</td>
<td>charindex - Returns an integer representing the starting position of an expression. charindex(expression1, expression2) </td></tr>
<tr>
<td>checkpoint</td>
<td>checkpoint - Writes all dirty pages (pages that have been updated since they were last written) to the database device. checkpoint </td></tr>
<tr>
<td>close</td>
<td>close - Deactivates a cursor. close cursor_name </td></tr>
<tr>
<td>col_length</td>
<td>col_length - Returns the defined length of a column. col_length(object_name, column_name) </td></tr>
<tr>
<td>col_name</td>
<td>col_name - Returns the name of the column whose table and column IDs are specified. col_name(object_id, column_id[, database_id]) </td></tr>
<tr>
<td>commit</td>
<td>commit - Marks the ending point of a user-defined transaction. commit | work]  </td></tr>
<tr>
<td>compare</td>
<td>compare - Compares two character strings based on alternate collation rules. compare (char_expression1, char_expression2 [, {collation_name | collation_ID}]) </td></tr>
<tr>
<td>compute Clause</td>
<td>compute Clause - Generates summary values that appear as start_of_select_statement ...] </td></tr>
<tr>
<td>connect to...disconnect</td>
<td>connect to...disconnect - Connects to the specified server and disconnects the connected server. connect to server_name disconnect </td></tr>
<tr>
<td>continue</td>
<td>continue - Restarts the while loop. continue is often activated by an if test. while boolean_expression statement break statement continue </td></tr>
<tr>
<td>convert</td>
<td>convert - Returns the specified value, converted to another datatype or a different datetime display format. convert (datatype [(length) | (precision[, scale])], expression[, style]) </td></tr>
<tr>
<td>cos</td>
<td>cos - Returns the cosine of the specified angle. cos(angle) </td></tr>
<tr>
<td>cot</td>
<td>cot - Returns the cotangent of the specified angle. cot(angle) </td></tr>
<tr>
<td>count</td>
<td>count - Returns the number of (distinct) non-null values count( expression) </td></tr>
<tr>
<td>create database</td>
<td>create database - Creates a new database. Use create database from the master database. create database database_name [, database_device [= size]]...] [, database_device [= size]]...]  </td></tr>
<tr>
<td>create default</td>
<td>create default - Specifies a value to insert in a column (or in all columns of a user- defined datatype) if no value is explicitly supplied at insert time. create default default_name as constant_expression </td></tr>
<tr>
<td>create existing table</td>
<td>create existing table - Allows you to map the proxy table to a table, view, or procedure at a remote location. create existing table table_name (column_list) [ on segment_name ] [ [ external {table | procedure} ] at pathname ] </td></tr>
<tr>
<td>create index</td>
<td>create index - Creates an index in ascending or descending order for each column; allows up to 31 columns per index; leaves a specified number of unused pages during index creation; allows specification of the number of steps in the distribution histogram for the index. create index index_name on [owner.]table_name (column_name [, column_name ]...)  </td></tr>
<tr>
<td>create procedure</td>
<td>create procedure - Creates a stored procedure or an extended stored procedure (ESP) that can take one or more user-supplied parameters. create procedure procedure_name[;number] [[(]@parameter_name datatype [(length) | (precision [, scale])] [= default] [, @parameter_name datatype [(length) | (precision [, scale])] [= default]]...[)]] as {SQL_statements | external name dll_name} </td></tr>
<tr>
<td>create proxy_table</td>
<td>create proxy_table - Creates a proxy table without specifying a column list. CIS derives the column list from the metadata it obtains from the remote table. create proxy_table table_name [ external table ] at pathname </td></tr>
<tr>
<td>create role</td>
<td>create role - Creates a user-defined role. create role role_name  </td></tr>
<tr>
<td>create rule</td>
<td>create rule - Specifies the domain of acceptable values for a particular column or for any column of a user-defined datatype. create rule rule_name as condition_expression </td></tr>
<tr>
<td>create schema</td>
<td>create schema - Creates a new collection of tables, views, and permissions for a database user. create schema authorization authorization_name create_oject_statement [ create_object_statement ... ] [ permission_statement ... ] </td></tr>
<tr>
<td>create table</td>
<td>create table - Specifies a locking scheme for the table being created; specifies ascending or descending index order when creating referential integrity constraints that depend on indexes; specifies the specifies a ratio of empty pages to be left for each filled page. create table .]table_name (column_name datatype {[{identity | null | not null}] | [ {{unique | primary key} | references [owner.]ref_table [(ref_column)] | check (search_condition)}]}... | {{unique | primary key} (column_name [{, column_name }...]) |foreign key (column_name [{, column_name}...]) references [owner.]ref_table [(ref_column [{, ref_column}...])] | check (search_condition) ... } [{, {next_column | next_constraint}}...]) reservepagegap = num_pages } ] [ [ external table ] at pathname ] </td></tr>
<tr>
<td>create trigger</td>
<td>create trigger - Creates a trigger, a type of stored procedure that is often used for enforcing integrity constraints. A trigger executes automatically when a user attempts a specified data modification statement on a specified table. create trigger trigger_name on table_name for {insert , update , delete} as SQL_statements Or, using the if update clause: create trigger trigger_name on table_name for {insert , update} as ...] SQL_statements ... SQL_statements]... </td></tr>
<tr>
<td>create view</td>
<td>create view - Creates a view, which is an alternative way of looking at the data in one or more tables. create view view_name [(column_name [, column_name]...)] as select select_statement  </td></tr>
<tr>
<td>curunreservedpgs</td>
<td>curunreservedpgs - Returns the number of free pages in the specified disk piece. curunreservedpgs(dbid, lstart, unreservedpgs) </td></tr>
<tr>
<td>data_pgs</td>
<td>data_pgs - Returns the number of pages used by the specified table or index. data_pgs(object_id, {data_oam_pg_id | index_oam_pg_id}) </td></tr>
<tr>
<td>datalength</td>
<td>datalength - Returns the actual length, in bytes, of the specified column or string. datalength(expression) </td></tr>
<tr>
<td>dateadd</td>
<td>dateadd - Returns the date produced by adding a given number of years, quarters, hours, or other date parts to the specified date. dateadd(date_part, integer, date) </td></tr>
<tr>
<td>datediff</td>
<td>datediff - Returns the difference between two dates. datediff(datepart, date1, date2) </td></tr>
<tr>
<td>datename</td>
<td>datename - Returns the name of the specified part of a datetime value. datename (datepart, date) </td></tr>
<tr>
<td>datepart</td>
<td>datepart - Returns the integer value of the specified part of a datetime value. datepart(date_part, date) </td></tr>
<tr>
<td>db_id</td>
<td>db_id - Returns the ID number of the specified database. db_id(database_name) </td></tr>
<tr>
<td>db_name</td>
<td>db_name - Returns the name of the database whose ID number is specified. db_name() </td></tr>
<tr>
<td>dbcc</td>
<td>dbcc - Database Consistency Checker (dbcc) checks the logical and physical consistency of a database. Use dbcc regularly as a periodic check or if you suspect any damage. dbcc checkalloc [(database_name [, fix | nofix])] dbcc checkcatalog [(database_name)] dbcc checkdb [(database_name [, skip_ncindex])] dbcc checkstorage [(database_name)] dbcc checktable({table_name|table_id}[, skip_ncindex]) dbcc checkverify(dbname) dbcc dbrepair (database_name, dropdb) dbcc fix_text ({table_name | table_id}) dbcc indexalloc ({table_name | table_id}, index_id [, {full | optimized | fast | null} [, fix | nofix]]) dbcc reindex ({table_name | table_id}) dbcc tablealloc ({table_name | table_id} [, {full | optimized | fast | null} [, fix | nofix]])| dbcc { traceon | traceoff } (3604,302) dbcc tune ( { ascinserts, {0 | 1 } , tablename | cleanup, {0 | 1 } | cpuaffinity, start_cpu [, on| off] | deviochar vdevno, "batch_size" | doneinproc { 0 | 1 } | maxwritedes, writes_per_batch } ) </td></tr>
<tr>
<td>deallocate cursor</td>
<td>deallocate cursor - Makes a cursor inaccessible and releases all memory resources committed to that cursor. deallocate cursor cursor_name </td></tr>
<tr>
<td>declare</td>
<td>declare - Declares the name and type of local variables for a batch or procedure. Variable declaration: declare @variable_name datatype [, @variable_name datatype]... Variable assignment: select @variable = {expression | select_statement} [, @variable = {expression | select_statement} ...] ] </td></tr>
<tr>
<td>declare cursor</td>
<td>declare cursor - Defines a cursor. declare cursor_name cursor for select_statement }] </td></tr>
<tr>
<td>degrees</td>
<td>degrees - Returns the size, in degrees, of an angle with the specified number of radians. degrees(numeric) </td></tr>
<tr>
<td>delete</td>
<td>delete - The readpast clause allows the delete command to delete [owner.]{table_name | view_name} owner.]{view_name | table_name [(index {index_name | table_name } [ prefetch size ])]} [, [owner.]{view_name | table_name [(index {index_name | table_name } [ prefetch size ])]} ...] ] </td></tr>
<tr>
<td>delete statistics</td>
<td>delete statistics - Removes statistics from the sysstatistics system table. delete statistics table_name [(column_name [,...])] </td></tr>
<tr>
<td>difference</td>
<td>difference - Returns the difference between two soundex values. difference(char_expr1, char_expr2) </td></tr>
<tr>
<td>disk init</td>
<td>disk init - Makes a physical device or file usable by Adaptive Server. disk init 1name = "device_name" , physname = "physicalname" , vdevno = virtual_device_number , size = number_of_blocks [, vstart = virtual_address , cntrltype = controller_number ] [, contiguous] </td></tr>
<tr>
<td>disk mirror</td>
<td>disk mirror - Creates a software mirror that immediately takes over when the primary device fails. disk mirror name = "device_name" , mirror = "physicalname" [ ,writes = { serial | noserial }] [ ,contiguous ] (OpenVMS only) </td></tr>
<tr>
<td>disk refit</td>
<td>disk refit - Rebuilds the master database's sysusages and sysdatabases system tables from information contained in sysdevices. disk refit </td></tr>
<tr>
<td>disk reinit</td>
<td>disk reinit - Rebuilds the master database's sysdevices system table. Use disk reinit as part of the procedure to restore the master database. disk reinit name = "device_name", physname = "physicalname" , vdevno = virtual_device_number , size = number_of_blocks [, vstart = virtual_address , cntrltype = controller_number] </td></tr>
<tr>
<td>disk remirror</td>
<td>disk remirror - Restarts disk mirroring after it is stopped by failure of a mirrored device or temporarily disabled by the disk unmirror command. disk remirror name = "device_name" </td></tr>
<tr>
<td>disk unmirror</td>
<td>disk unmirror - Suspends disk mirroring initiated with the disk mirror command to allow hardware maintenance or the changing of a hardware device. disk unmirror name = "device_name" [ ,side = { "primary" | secondary }] [ ,mode = { retain | remove }] </td></tr>
<tr>
<td>drop database</td>
<td>drop database - Removes one or more databases from Adaptive Server. drop database database_name [, database_name]... </td></tr>
<tr>
<td>drop default</td>
<td>drop default - Removes a user-defined default. drop default default_name [, default_name]... </td></tr>
<tr>
<td>drop index</td>
<td>drop index - Removes an index from a table in the current database. drop index table_name.index_name [, table_name.index_name]... </td></tr>
<tr>
<td>drop procedure</td>
<td>drop procedure - Removes a procedure. drop proc procedure_name [, procedure_name] ... </td></tr>
<tr>
<td>drop role</td>
<td>drop role - Drops a user-defined role. drop role role_name  </td></tr>
<tr>
<td>drop rule</td>
<td>drop rule - Removes a user-defined rule. drop rule rule_name [, rule_name]... </td></tr>
<tr>
<td>drop table</td>
<td>drop table - Removes a table definition and all of its data, indexes, triggers, and permissions from the database. drop table [owner.]table_name [, [owner.]table_name ]... </td></tr>
<tr>
<td>drop trigger</td>
<td>drop trigger - Removes a trigger. drop trigger trigger_name [, trigger_name]... </td></tr>
<tr>
<td>drop view</td>
<td>drop view - Removes one or more views from the current database. drop view view_name [, view_name]... </td></tr>
<tr>
<td>dump database</td>
<td>dump database - Makes a backup copy of the entire database, including the transaction log, in a form that can be read in with load database. Dumps and loads are performed through Backup Server. dump database database_name to stripe_device [ at backup_server_name ] ] [ ]...] , , retaindays = number_days, , notify = {client | operator_console} }] </td></tr>
<tr>
<td>dump transaction</td>
<td>dump transaction - Dumps only completed transactions. To make a routine or standby access log dump: dump tran database_name to stripe_device [ at backup_server_name ] ] [ ]...] , , retaindays = number_days, , notify = {client | operator_console} standby_access }] To truncate the log without making a backup copy: dump tran database_name with truncate_only To truncate a log that is filled to capacity.Use only as a last resort dump tran database_name with no_log To back up the log after a database device fails: dump tran database_name to stripe_device [ at backup_server_name ] ] [ ]...] , , retaindays = number_days, , no_truncate, notify = {client | operator_console}}] </td></tr>
<tr>
<td>execute</td>
<td>execute - Runs a procedure. ] [@return_status = ] [[database.]owner.]procedure_name[;number] [[@parameter_name =] value | [@parameter_name =] @variable [,[@parameter_name =] value | [@parameter_name =] @variable ...]]  </td></tr>
<tr>
<td>exp</td>
<td>exp - Returns the value that results from raising the constant e to the specified power. exp(approx_numeric) </td></tr>
<tr>
<td>fetch</td>
<td>result set. fetch cursor_name [ into fetch_target_list ] </td></tr>
<tr>
<td>floor</td>
<td>floor - Returns the largest integer that is less than or equal to the specified value. floor(numeric) </td></tr>
<tr>
<td>getdate</td>
<td>getdate - Returns the current system date and time. getdate() </td></tr>
<tr>
<td>goto Label</td>
<td>goto Label - Branches to a user-defined label. label: goto label </td></tr>
<tr>
<td>grant</td>
<td>grant - Assigns permissions to users or to user-defined roles. To grant permission to access database objects: grant {all | permission_list} on { table_name [(column_list)] | view_name[(column_list)] | stored_procedure_name} to {public | name_list | role_name} To grant permission to execute certain commands: grant {all | command_list} to {public | name_list | role_name} To grant a role to a user or a role: grant {role role_granted [, role_granted ...]} to grantee [, grantee...] </td></tr>
<tr>
<td>group by and having</td>
<td>group by and having - Used in select statements to divide a table into groups and to return only groups that match conditions in the having clause. Start of select statement aggregate_free_expression [, aggregate_free_expression]...] End of select statement </td></tr>
<tr>
<td>hextoint</td>
<td>hextoint - Returns the platform-independent integer equivalent of a hexadecimal string. hextoint (hexadecimal_string) </td></tr>
<tr>
<td>host_id</td>
<td>host_id - Returns the host process ID or the client process. host_id() </td></tr>
<tr>
<td>host_name</td>
<td>host_name - Returns the current host computer name of the client process. host_name() </td></tr>
<tr>
<td>if...else</td>
<td>if...else - Imposes conditions on the execution of a SQL statement. if logical_expression statements statement] </td></tr>
<tr>
<td>index_col</td>
<td>index_col - Returns the name of the indexed column in the specified table or view. index_col (object_name, index_id, key_# [, user_id]) </td></tr>
<tr>
<td>index_colorder</td>
<td>index_colorder - Returns the column order. index_colorder (object_name, index_id, key_# [, user_id]) </td></tr>
<tr>
<td>insert</td>
<td>insert ]{table_name|view_name} [(column_list)] {values (expression [, expression]...) |select_statement } </td></tr>
<tr>
<td>inttohex</td>
<td>inttohex - Returns the platform-independent hexadecimal equivalent of the specified integer. inttohex (integer_expression) </td></tr>
<tr>
<td>is_sec_service_on</td>
<td>is_sec_service_on - Returns 1 if the security service is active and 0 if it is not. is_sec_service_on(security_service_nm) </td></tr>
<tr>
<td>isnull</td>
<td>isnull - Substitutes the value specified in expression2 when expression1 evaluates to NULL. isnull(expression1, expression2) </td></tr>
<tr>
<td>kill</td>
<td>kill - Kills a process. kill spid </td></tr>
<tr>
<td>lct_admin</td>
<td>lct_admin - Returns the current value of the last-chance threshold. Aborts transactions in a transaction log that has reached its last-chance threshold. lct_admin({{"lastchance" | "logfull" }, database_id |"reserve", {log_pages | 0 } | "abort", process-id [, database-id]}) </td></tr>
<tr>
<td>load database</td>
<td>load database - Loads a backup copy of a user database, including its transaction log, that was created with dump database. load database database_name from stripe_device [ ]...] , , listonly [= full], headeronly, notify = {client | operator_console} }]] </td></tr>
<tr>
<td>load transaction</td>
<td>load transaction - Loads a backup copy of the transaction log that was created with the dump transaction command. load tran database_name from stripe_device [ ]...] , , listonly [= full], headeronly, notify = {client | operator_console} until_time = datetime}]] </td></tr>
<tr>
<td>lock table</td>
<td>lock table - Explicitly locks a table within a transaction. lock table table_name in {share | exclusive } mode [ wait [ numsecs ] | nowait ] </td></tr>
<tr>
<td>log</td>
<td>log - Returns the natural logarithm of the specified number. log(approx_numeric) </td></tr>
<tr>
<td>log10</td>
<td>log10 - Returns the base 10 logarithm of the specified number. log10(approx_numeric) </td></tr>
<tr>
<td>lower</td>
<td>lower - Returns the lowercase equivalent of the specified expression. lower(char_expr) </td></tr>
<tr>
<td>ltrim</td>
<td>ltrim - Returns the specified expression, trimmed of leading blanks. ltrim(char_expr) </td></tr>
<tr>
<td>max</td>
<td>max - Returns the highest value in an expression. max(expression) </td></tr>
<tr>
<td>min</td>
<td>min - Returns the lowest value in a column. min(expression) </td></tr>
<tr>
<td>mut_excl_roles</td>
<td>mut_excl_roles - Returns information about the mutual exclusivity between two roles. mut_excl_roles ("role1", "role2" ["membership" | "activation"]) </td></tr>
<tr>
<td>object_id</td>
<td>object_id - Returns the object ID of the specified object. object_id(object_name) </td></tr>
<tr>
<td>object_name</td>
<td>object_name - Returns the name of the object whose object ID is specified. object_name(object_id[, database_id]) </td></tr>
<tr>
<td>online database</td>
<td>online database - Brings a database online after loading a transaction log dumped with the standby_access option. online database database_name  </td></tr>
<tr>
<td>open</td>
<td>open - Opens a cursor for processing. open cursor_name </td></tr>
<tr>
<td>order by Clause</td>
<td>order by Clause - Returns query results in the specified column(s) in sorted order. column_name | select_list_number | expression} [,{ column_name select_list_number|expression} ]...]  </td></tr>
<tr>
<td>patindex</td>
<td>patindex - Returns the starting position of the first occurrence of a specified pattern. patindex("%pattern%", char_expr [, using {bytes | characters | chars} ] ) </td></tr>
<tr>
<td>pi</td>
<td>pi - Returns the constant value 3.1415926535897936. pi() </td></tr>
<tr>
<td>power</td>
<td>power - Returns the value that results from raising the specified number to a given power. power(value, power) </td></tr>
<tr>
<td>prepare transaction</td>
<td>prepare transaction - Used by DB-Library in a two-phase commit application to see if a server is prepared to commit a transaction. prepare tran </td></tr>
<tr>
<td>print</td>
<td>print - Prints a user-defined message on the user's screen. print {format_string | @local_variable | @@global_variable} [, arg_list] </td></tr>
<tr>
<td>proc_role</td>
<td>proc_role - Returns 1 if the user has the correct role to execute the procedure; 0 if the user does not have this role. proc_role ("sa_role" | "sso_role" | "oper_role" | "replication_role" | "role_name" ) </td></tr>
<tr>
<td>ptn_data_pgs</td>
<td>ptn_data_pgs - Returns the number of data pages used by a partition. ptn_data_pgs(object_id, partition_id) </td></tr>
<tr>
<td>radians</td>
<td>radians - Returns the size, in radians, of an angle with the specified number of degrees. radians(numeric) </td></tr>
<tr>
<td>raiserror</td>
<td>raiserror - Prints a user-defined error message on the user's screen and sets a system flag to record that an error condition has occurred. raiserror error_number [{format_string | @local_variable}] [, arg_list]  </td></tr>
<tr>
<td>rand</td>
<td>rand - Returns a random value between 0 and 1, which is generated using the specified seed value. rand() </td></tr>
<tr>
<td>readtext</td>
<td>have exclusive locks on them, without waiting and without generating a message. readtext [owner.]table_name.column_name text_pointer offset size  </td></tr>
<tr>
<td>reconfigure</td>
<td>reconfigure - The reconfigure command currently has no effect; it is included to allow existing scripts to run without modification. In previous releases, reconfigure was required after the system procedure sp_configure to implement new configuration parameter settings. reconfigure </td></tr>
<tr>
<td>reorg</td>
<td>new pages, depending on the option used. reorg reclaim_space tablename reorg compact tablename reorg rebuild tablename </td></tr>
<tr>
<td>replicate</td>
<td>replicate - Returns a string consisting of the specified expression repeated a given number of times. replicate (char_expr, integer_expr) </td></tr>
<tr>
<td>reserved_pgs</td>
<td>reserved_pgs - Returns the number of pages allocated to the specified table or index. reserved_pgs(object_id, {doampg|ioampg}) </td></tr>
<tr>
<td>return</td>
<td>return - Exits from a batch or procedure unconditionally and provides an optional return status. Statements following return are not executed. return  </td></tr>
<tr>
<td>reverse</td>
<td>reverse - Returns the specified string with characters listed in reverse order. reverse(expression) </td></tr>
<tr>
<td>revoke</td>
<td>revoke - Revokes permissions or roles from users or roles. To revoke permission to access database objects: revoke {all | permission_list} on { table_name [(column_list)] | view_name [(column_list)] | stored_procedure_name} from {public | name_list | role_name} To revoke permission to create database objects, execute set proxy, or execute set session authorization: revoke {all | command_list} from {public | name_list | role_name} To revoke a role from a user or another role: revoke role {role_name [, role_name ...]} from {grantee [, grantee ...]} </td></tr>
<tr>
<td>right</td>
<td>right - The rightmost part of the expression with the specified number of characters. right(expression, integer_expr) </td></tr>
<tr>
<td>role_contain</td>
<td>role_contain - Returns 1 if role2 contains role1. role_contain("role1", "role2") </td></tr>
<tr>
<td>role_id</td>
<td>role_id - Returns the system role ID of the role whose name you specify. role_id("role_name") </td></tr>
<tr>
<td>role_name</td>
<td>role_name - Returns the name of a role whose system role ID you specify. role_name() </td></tr>
<tr>
<td>rollback</td>
<td>rollback - Rolls back a user-defined transaction to the named savepoint in the transaction or to the beginning of the transaction. rollback {tran | work}  </td></tr>
<tr>
<td>rollback trigger</td>
<td>rollback trigger - Rolls back the work done in a trigger, including the data modification that caused the trigger to fire, and issues an optional raiserror statement. rollback trigger  </td></tr>
<tr>
<td>round</td>
<td>round - Returns the value of the specified number, rounded to a given number of decimal places. round(number, decimal_places) </td></tr>
<tr>
<td>rowcnt</td>
<td>specified table. </td></tr>
<tr>
<td>rtrim</td>
<td>rtrim - Returns the specified expression, trimmed of trailing blanks. rtrim(char_expr) </td></tr>
<tr>
<td>save transaction</td>
<td>save transaction - Sets a savepoint within a transaction. save transaction savepoint_name </td></tr>
<tr>
<td>select</td>
<td>select - Allows specifying the locking scheme with select have exclusive locks on them without waiting and without generating a message. select select_list owner.]table_name reservepagegap = num_pages } ] ] owner.]{view_name|table_name [(index {index_name | table_name } ] )]} [,[owner.]{view_name|table_name [(index {index_name | table_name } ] )]} ]...] aggregate_free_expression [, aggregate_free_expression]... ] owner.]{table_name.|view_name.}] column_name | select_list_number | expression} [,{[[owner.]{table_name|view_name.}] column_name | select_list_number | expression} ]...] ...]] }] | [ read committed | 1 ] | [ repeatable read | 2 ]| [ serializable | 3 ] } ] </td></tr>
<tr>
<td>set</td>
<td>set - Sets Adaptive Server query-processing options for the duration of the user's work session. Can be used to set some options inside a trigger or stored procedure. Can also be used to activate or deactivate a role in the current session. set ansinull {on | off} set ansi_permissions {on | off} set arithabort {on | off} set arithignore {on | off} set {chained, close on endtran, nocount, noexec, parseonly, procid, self_recursion, showplan, sort_resources} {on | off} set char_convert {off | on | charset } set cis_rpc_handling {on | off} set {datefirst number, dateformat format, language language} set fipsflagger {on | off} set flushmessage {on | off} set identity_insert ]table_name {on | off} set lock { wait [ numsecs ] | nowait } set offsets {select, from, order, compute, table, procedure, statement, param, execute} {on | off} set parallel_degree number set prefetch set process_limit_action {abort | quiet | warning} set proxy set quoted_identifier {on | off} set role {"sa_role" | "sso_role" | "oper_role" | role_name } {on | off} set scan_parallel_degree number set session authorization set showplan {on | off} set sort_resources {on | off} set statistics {io, subquerycache, time} {on | off} set string_rtruncation {on | off} set table count number set textsize {number} set transaction isolation level { [ read uncommitted | 0 ] | [ read committed | 1 ] | [ repeatable read | 2 ]| [ serializable | 3 ] } set transactional_rpc {on | off} </td></tr>
<tr>
<td>setuser</td>
<td>setuser - Allows a Database Owner to impersonate another user. setuser ["user_name"] </td></tr>
<tr>
<td>show_role</td>
<td>show_role - Shows the login's currently active system-defined roles. show_role() </td></tr>
<tr>
<td>show_sec_services</td>
<td>show_sec_services - Lists the security services that are active for the session. show_sec_services() </td></tr>
<tr>
<td>shutdown</td>
<td>shutdown - Shuts down the Adaptive Server from which the command is issued, its local Backup Server, or a remote Backup Server. This command can be issued only by a System Administrator. shutdown  </td></tr>
<tr>
<td>sign</td>
<td>sign - Returns the sign (+1 for positive, 0, or -1 for negative) of the specified value. sign(numeric) </td></tr>
<tr>
<td>sin</td>
<td>sin - Returns the sine of the specified angle (in radians). sin(approx_numeric) </td></tr>
<tr>
<td>sortkey</td>
<td>sortkey - Generates values that can be used to order results based on collation behavior. sortkey (char_expression [, {collation_name | collation_ID}]) </td></tr>
<tr>
<td>soundex</td>
<td>soundex - Returns a 4-character code representing the way an expression sounds. soundex(char_expr) </td></tr>
<tr>
<td>space</td>
<td>space - Returns a string consisting of the specified number of single-byte spaces. space(integer_expr) </td></tr>
<tr>
<td>sqrt</td>
<td>sqrt - Returns the square root of the specified number. sqrt(approx_numeric) </td></tr>
<tr>
<td>str</td>
<td>str - Returns the character equivalent of the specified number. str(approx_numeric [, length [, decimal] ]) </td></tr>
<tr>
<td>stuff</td>
<td>stuff - Returns the string formed by deleting a specified number of characters from one string and replacing them with another string. stuff(char_expr1, start, length, char_expr2) </td></tr>
<tr>
<td>substring</td>
<td>substring - Returns the string formed by extracting the specified number of characters from another string. substring(expression, start, length) </td></tr>
<tr>
<td>sum</td>
<td>sum - Returns the total of the values. sum( expression) </td></tr>
<tr>
<td>suser_id</td>
<td>suser_id - Returns the server user's ID number from the syslogins table. suser_id() </td></tr>
<tr>
<td>suser_name</td>
<td>suser_name - Returns the name of the current server user or the user whose server ID is specified. suser_name() </td></tr>
<tr>
<td>tan</td>
<td>tan - Returns the tangent of the specified angle (in radians). tan(angle) </td></tr>
<tr>
<td>textptr</td>
<td>textptr - Returns the 16-byte binary pointer to the first page of the specified text column. textptr(column_name) </td></tr>
<tr>
<td>textvalid</td>
<td>textvalid - Returns 1 if the pointer to the specified text column is valid; 0 if it is not. textvalid("table_name.column_name", textpointer) </td></tr>
<tr>
<td>truncate table</td>
<td>truncate table [owner.]table_name </td></tr>
<tr>
<td>tsequal</td>
<td>tsequal - Compares timestamp values to prevent update on a </td></tr>
<tr>
<td>union Operator</td>
<td>union Operator - Returns a single result set that combines the are eliminated from the result set unless the all keyword is specified. select select_list select select_list ]...  </td></tr>
<tr>
<td>update</td>
<td>update - The readpast clause allows the update command to update [owner.]{table_name | view_name} set [[owner.]{table_name.|view_name.}] column_name1 = {expression1|NULL|(select_statement)} | variable_name1 = {expression1|NULL|(select_statement)} [, column_name2 = {expression2|NULL|(select_statement)}]... | [, variable_name2 = {expression2|NULL|(select_statement)}]... owner.]{view_name | table_name [(index {index_name | table_name } [ prefetch size ])]} [,[owner.]{view_name | table_name [(index {index_name | table_name } [ prefetch size ])]}] ...]  </td></tr>
<tr>
<td>update partition statistics</td>
<td>update partition statistics - Updates information about the number of pages each partition for a partitioned table. update partition statistics table_name  </td></tr>
<tr>
<td>update statistics</td>
<td>update statistics - Updates information about the distribution of key values in specified indexes or for specified columns, for all columns in an index, or for all columns on a table; allows specifying the number of steps for a histogram. update statistics table_name [ | [( column_list ) ] ] update all statistics table_name update index statistics table_name  </td></tr>
<tr>
<td>upper</td>
<td>upper - Returns the uppercase equivalent of the specified string. upper(char_expr) </td></tr>
<tr>
<td>use</td>
<td>use - Specifies the database with which you want to work. use database_name </td></tr>
<tr>
<td>used_pgs</td>
<td>used_pgs - Returns the number of pages used by the specified table and its clustered index, or the number of pages in a nonclustered index. used_pgs(object_id, doampg, ioampg) </td></tr>
<tr>
<td>user</td>
<td>user - Returns the name of the current user. user </td></tr>
<tr>
<td>user_id</td>
<td>user_id - Returns the ID number of the specified user or of the current user in the database. user_id() </td></tr>
<tr>
<td>user_name</td>
<td>user_name - Returns the name within the database of the specified user or of the current user. user_name() </td></tr>
<tr>
<td>valid_name</td>
<td>valid_name - Returns 0 if the specified string is not a valid identifier or a number other than 0 if the string is a valid identifier. valid_name(character_expression) </td></tr>
<tr>
<td>valid_user</td>
<td>valid_user - Returns 1 if the specified ID is a valid user or alias in at least one database on this Adaptive Server. valid_user(server_user_id) </td></tr>
<tr>
<td>waitfor</td>
<td>waitfor - Specifies a specific time, a time interval, or an event for the execution of a statement block, stored procedure, or transaction. waitfor { delay time | time time | errorexit | processexit | mirrorexit } </td></tr>
<tr>
<td>where Clause</td>
<td>where Clause - Sets the search conditions in a select, insert, update, or delete statement. Search conditions immediately follow the keyword where in a select, insert, update, or delete statement. If you use more than one search condition in a single statement, connect the conditions with and or or where expression comparison_operator expression where expression like "match_string" where expression is null where expression between expression and expression where expression in ({value_list | subquery}) where exists (subquery) where expression comparison_operator {any | all} (subquery) where column_name join_operator column_name where logical_expression where expression {and | or} expression </td></tr>
<tr>
<td>while</td>
<td>while - Sets a condition for the repeated execution of a statement or statement block. The statement(s) are executed repeatedly, as long as the specified condition is true. while logical_expression statement </td></tr>
<tr>
<td>writetext</td>
<td>writetext [owner.]table_name.column_name text_pointer data </td></tr></tbody></table>

JohnPhan 发表于 2008-2-27 10:31:27

官方的ASE Quick Reference Guide

另一个版本的ASE Quick Reference Guide。官方的。

页: [1]

PowerBuilder(PB)BBS社区's Archiver

Quick Reference Guide for ASE

官方的ASE Quick Reference Guide