Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

Sybase ASE - Transact-SQL System Functions


This article describes the Transact-SQL system functions supported by Sybase Adaptive Server Enterprise (ASE) 15.0.x and earlier.

Overview

Function Description
UUID/GUID Generation Functions
NEWID() Generates global unique IDs (GUID/UUID)

UUID/GUID Generation Functions

NEWID

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Sybase Request SQLWays

sqlways/sybase/system-functions.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement