Sybase @@ Variables
The sybase internal variables most used by developers are listed in the table below. This is not a complete list.
| Code | Description |
|---|---|
| Example(s) | |
| @@boottime | Time of last reboot (From version 12.5) |
| 9/17/05 09:00:00.566 PM | |
| @@cis_rpc_handling | |
| @@cis_version | The CIS Version number. |
| not configured | |
| @@connections | |
| @@dbts | |
| @@error | The most recently generated error number. |
| 2601 | |
| @@errorlog | |
| @@identity | |
| @@isolation | |
| @@langid | |
| @@language | |
| @@max_connections | The maximum number of simultaneous connections that the server is configured to support. |
| 2028 | |
| @@nestlevel | Current stored procedure/trigger nesting level. (0 to 16) |
| 0 | |
| @@rowcount | 1) Number of rows affected by last query. 2) Current cursor rows fetched. 3) DML rowcount causing trigger to fire (on first trigger line) |
| 127 | |
| @@servername | The server name |
| MYSERVER | |
| @@spid | Server process id of this process |
| 44 | |
| @@sqlstatus | Fetch statement status info. Zero = No Warnings, Non-Zero = Warnings |
| 0 | |
| @@tranchained | Current transaction mode. 0 = Unchained, 1 = Chained |
| 0 | |
| @@trancount | Transaction nesting level of current user transaction |
| 0 | |
| @@version | Sybase Version |
| Adaptive Server Enterprise/11.9.2.6/1290/P/EBF 10491 ESD1/Sun_srv4/OS 5.5.1/FBO/Mon Jul 15 06:54:22 2002 | |
| @@version_as_integer | Sybase Version as an Integer Value (From Version 12.5) |
| 12500 |
|
Roger Hall COMPUSPEC |
|