USE [site_fuchs]
GO
/****** Object:  UserDefinedFunction [dbo].[ocms_fn_useraccount_id]    Script Date: 02.12.2020 21:05:05 ******/
DROP FUNCTION [dbo].[ocms_fn_useraccount_id]
GO
/****** Object:  UserDefinedFunction [dbo].[ocms_fn_useraccount_id]    Script Date: 02.12.2020 21:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



CREATE FUNCTION [dbo].[ocms_fn_useraccount_id] (
)
RETURNS varchar(5)
AS
BEGIN
  DECLARE @NewAccount varchar(5) = [dbo].[ocms_fn_generatePassword] (5,0,1,0);

  WHILE EXISTS( SELECT * FROM [dbo].[ocms_useraccounts] WHERE [useraccount_id] = @NewAccount)
	BEGIN
		SET @NewAccount = [dbo].[ocms_fn_generatePassword] (5,0,1,0);
	END

  RETURN @NewAccount;
END;
GO
ALTER AUTHORIZATION ON [dbo].[ocms_fn_useraccount_id] TO  SCHEMA OWNER 
GO