database/sp_GenerateRandomUniqueUrlKey.sql at master · ArkansasRepeaterCouncil/database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
CREATE PROCEDURE [dbo].[sp_GenerateRandomUniqueUrlKey] @UrlKey char(32) output
AS
BEGIN
	DECLARE @key char(32)
	Set @key = NULL
	EXEC dbo.sp_GenerateRandomKey @key output

	While exists (select 1 from RequestWorkflows where UrlKey=@key)
	Begin
		EXEC dbo.sp_GenerateRandomKey @key output
	End

	Set @UrlKey = @key;
END;