Hola
Mi fuerte es C#, pero se me cruzo esto en SQL y creo que tiene que haber una
forma mas corta de hacerlo. Este es mi codigo de SQL, hay alguna forma de
que si los valores de los parametros son -1 me traiga todos los datos. O
como lo harian?
CREATE PROCEDURE Messages_Get
@MessageId int = -1,
@SenderGender bit = -1,
@Text varchar(15) = -1,
@Number int = -1
As
If @MessageId = -1
If @SenderGender = -1 AND @Text = -1 AND @Number = -1
Select * from Messages
Order By Date Desc
If @SenderGender != -1 AND @Text != -1 AND @Number != -1
Select * from Messages
Where SenderGender = @SenderGender And Text Like @Text And Number =
@Number
Order By Date Desc
If @SenderGender != -1 AND @Text != -1 AND @Number = -1
Select * from Messages
Where SenderGender = @SenderGender And Text Like @Text
Order By Date Desc
If @SenderGender != -1 AND @Text = -1 AND @Number = -1
Select * from Messages
Where SenderGender = @SenderGender
Order By Date Desc
If @SenderGender = -1 AND @Text = -1 AND @Number != -1
Select * from Messages
Where Number = @Number
If @SenderGender = -1 AND @Text != -1 AND @Number = -1
Select * from Messages
Where Text Like @Text
Else
Select * from Messages Where MessageId = @MessageId Order By Date Desc
Gracias
Leer las respuestas