Skip to content

Instantly share code, notes, and snippets.

View pwelter34's full-sized avatar

Paul Welter pwelter34

View GitHub Profile
@pwelter34
pwelter34 / GenerateULID.sql
Created July 23, 2025 15:29
SQL Server ULID Implementation
CREATE FUNCTION [dbo].[GenerateULID]
(
@random AS BINARY(10),
@timestamp AS DATETIME2 = NULL
)
RETURNS VARCHAR(26)
AS
BEGIN
-- Crockford's base32 alphabet
DECLARE @alphabet VARCHAR(32) = '0123456789ABCDEFGHJKMNPQRSTVWXYZ'