- IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[aspne2u4].[IIF]') AND xtype in (N'FN', N'IF', N'TF'))
- DROP FUNCTION [aspne2u4].[IIF]
- GO
-
- SET QUOTED_IDENTIFIER ON
- GO
-
- SET ANSI_NULLS OFF
- GO
-
- CREATE FUNCTION IIF
- (
- @Condition bit,
- @TruePart sql_variant,
- @FalsePart sql_variant
- )
- RETURNS sql_variant
- AS
- BEGIN
- IF @Condition = 1
- RETURN @TruePart
- RETURN @FalsePart
- END
- GO
-
- SET QUOTED_IDENTIFIER OFF
- GO
-
- SET ANSI_NULLS ON
- GO
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[aspne2u4].[IIF]') AND xtype in (N'FN', N'IF', N'TF'))
DROP FUNCTION [aspne2u4].[IIF]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE FUNCTION IIF
(
@Condition bit,
@TruePart sql_variant,
@FalsePart sql_variant
)
RETURNS sql_variant
AS
BEGIN
IF @Condition = 1
RETURN @TruePart
RETURN @FalsePart
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO