- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Select * from client where type=1 and clientid=2 if clientid=0 which I pass it from C# then Select * from client where type=1 //and clientid=0 would be taken out I tried: Select * from client where type=1 case when (t.clientid ='0' then '' when t.clientid <> '0' then and t.clientid = '2') order by [id] desc But, it said Incorrect syntax near the keyword 'case'.
|How to format datetime as mm/dd/yyyy||6||63|
|Microsoft Dynamics GP, Microsoft Dynamics Retail Management Systems, Microsoft SQL Server version compatibilities||3||60|
|PERFORMANCE OF SQL QUERY||13||58|
|How to place a condition in a filter criteria in t-sql?||12||36|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!