Returns a new GUID value as a string.

Syntax

---

CURRENT_GUID()

Returns

---

GUID

Usage

---

The CURRENT_GUID function returns a new GUID value as a 38-character string.

Examples

---

INSERT INTO Transactions
VALUES (CURRENT_GUID(), CURRENT_TIMESTAMP(), CURRENT_USER(),
        'DEBIT', 200.00)

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: