uuid函数
CREATE OR REPLACE function get_uuid
returns guid nvarchar(36)
language sqlscript as
begin
guid := lower(SYSUUID);
guid :=substring(guid,1,8)||'-'||substring(guid,9,4)||'-'||substring(guid,13,4)||'-'||substring(guid,17,4)||'-'||substring(guid,21,12);
end;
SELECT get_uuid() FROM dummy;

浙公网安备 33010602011771号