Fórum
Dynamic Query with AND, OR criteria
Tina Agrawal, modificado 12 Anos atrás.
Dynamic Query with AND, OR criteria
Expert Postagens: 297 Data de Entrada: 03/01/08 Postagens Recentes
Hi All,
I am using Dynamic Query to get the result from my custom table.
I want to execute Dynamic Query with "AND"(&&) as well as with "or"(||) criteria.
SQL which resembles to my need is something like this
Let me know any pointers.
Regards,
Tina Agrawal
I am using Dynamic Query to get the result from my custom table.
I want to execute Dynamic Query with "AND"(&&) as well as with "or"(||) criteria.
SQL which resembles to my need is something like this
Select *
From CustomeTable ct
Where (ct.firstColumn = "abc" AND ct.secondColumn = "xyz")
OR ct.thirdColumn = "123";
Let me know any pointers.
Regards,
Tina Agrawal