USE [site_fuchs]
GO
/****** Object:  UserDefinedFunction [dbo].[ocms_admin_checkUserExists]    Script Date: 02.12.2020 21:05:05 ******/
DROP FUNCTION [dbo].[ocms_admin_checkUserExists]
GO
/****** Object:  UserDefinedFunction [dbo].[ocms_admin_checkUserExists]    Script Date: 02.12.2020 21:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[ocms_admin_checkUserExists]
(
	@useraccount_id varchar(5)
)
RETURNS bit
AS
BEGIN
	DECLARE @RET bit;

	SET @RET = IIF(EXISTS (SELECT * FROM [dbo].[ocms_useraccounts] as ua WHERE [useraccount_id] = @useraccount_id AND ua.[DateDeleted] is null AND ua.[DateDisabled] is null), 1, 0);

	RETURN @RET;

END
GO
ALTER AUTHORIZATION ON [dbo].[ocms_admin_checkUserExists] TO  SCHEMA OWNER 
GO