User Documentation
Ispirer Capabilities - Sybase Migration
Pricing
This article describes the Transact-SQL system functions supported by Sybase Adaptive Server Enterprise (ASE) 15.0.x and earlier.
| Function | Description |
|---|---|
| UUID/GUID Generation Functions | |
| NEWID() | Generates global unique IDs (GUID/UUID) |
| Sybase ASE - NEWID | |
|---|---|
| Syntax | NEWID([p]) |
| Description | Generates global unique IDs (GUID/UUID) |
| Parameters | if p is 0 - GUID does not include dashes, if p is 1 - GUID includes dashes, if p is 0x0 - GUID is returned as binary data |
| Return Value | if p is 0 - return value is VARCHAR(32), if p is 1 - VARCHAR(36), and if p is 0x0 - VARBINARY(16) |
| Default | p is 0 |
| Usage Notes | Can be used in defaults and triggers |
| Error Handling | NULL is returned if wrong p is specified |
| Standards | Sybase ASE Transact-SQL Extension |