duda con funcion
Publicado por Paloma (7 intervenciones) el 16/07/2008 00:02:26
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[Valida_S_Cinema](@ID INT,@Cine varchar(100),@Cadena int,@Plaza int)
RETURNS TABLE
AS
IF @ID=0 THEN
RETURN (SELECT COUNT (cinDescription) AS Total
FROM [PALOMA_DB_ARTECINEMA].[dbo].[S_Cinema]
WHERE cinDescription = @Cine
AND chID = @Cadena
AND cityID = @Plaza
)
ELSE
RETURN (SELECT COUNT (cinDescription) AS Total
FROM [PALOMA_DB_ARTECINEMA].[dbo].[S_Cinema]
WHERE cinID <> @ID
AND cinDescription = @Cine
AND chID = @Cadena
AND cityID = @Plaza
)
END IF
Me genera errores. Gracias de antemano
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[Valida_S_Cinema](@ID INT,@Cine varchar(100),@Cadena int,@Plaza int)
RETURNS TABLE
AS
IF @ID=0 THEN
RETURN (SELECT COUNT (cinDescription) AS Total
FROM [PALOMA_DB_ARTECINEMA].[dbo].[S_Cinema]
WHERE cinDescription = @Cine
AND chID = @Cadena
AND cityID = @Plaza
)
ELSE
RETURN (SELECT COUNT (cinDescription) AS Total
FROM [PALOMA_DB_ARTECINEMA].[dbo].[S_Cinema]
WHERE cinID <> @ID
AND cinDescription = @Cine
AND chID = @Cadena
AND cityID = @Plaza
)
END IF
Me genera errores. Gracias de antemano
Valora esta pregunta


0