lundi 27 avril 2020

IF..ELSE Logic in stored procedure

I have a stored procedure where I need to pull data from a table column based on an input parameter.

If the input parameter is 'Y' I need to pull only 'Y' values from the table column, if it is 'N', I need to pull all values irrespective of 'Y' or 'N' or NULL.

Aucun commentaire:

Enregistrer un commentaire