MySQL
```sql
DELIMITER //
CREATE PROCEDURE GenerateUUID()
BEGIN
SELECT UUID();
END //
DELIMITER ;
```
PostgreSQL
确保安装了`uuid-ossp`扩展:
```sql
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
```
然后,你可以创建一个存储过程:
```sql
CREATE OR REPLACE FUNCTION GenerateUUID()
RETURNS uuid AS $$
BEGIN
RETURN uuid_generate_v4();
END;
$$ LANGUAGE plpgsql;
```
SQL Server
```sql
CREATE PROCEDURE GenerateUUID()
AS
BEGIN
SELECT NEWID() AS UUID;
END;
```
Oracle
```sql
CREATE OR REPLACE PROCEDURE GenerateUUID
IS
v_uuid VARCHAR2(36);
BEGIN
v_uuid := RAWTOHEX(DBMS_RANDOM.VALUE(1, 2128-1));
v_uuid := TO_CHAR(TO_NUMBER(SUBSTR(v_uuid, 1, 8), 'XXXXXXXX') 1000000000000)
'-'
TO_CHAR(TO_NUMBER(SUBSTR(v_uuid, 9, 4), 'XXXXXXXX') 10000)
'-'
TO_CHAR(TO_NUMBER(SUBSTR(v_uuid, 13, 4), 'XXXXXXXX'))
'-'
TO_CHAR(TO_NUMBER(SUBSTR(v_uuid, 17, 4), 'XXXXXXXX'))
'-'
TO_CHAR(TO_NUMBER(SUBSTR(v_uuid, 21), 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'));
DBMS_OUTPUT.PUT_LINE(v_uuid);
END;
```