SQL Server compact- Query that return 2 constant columns even if query didn't return data
0
votes
2
answers
1189
views
Please look at the following simple query:
Select CustomerID
From Customers c
Where c.CustomerId = "1234"
I want to write similar query that does the following:
Always return 2 columns with constant string instead of CustomerID in this structure:
If value was found then return 2 columns:
Found Value in DB, CustomerId
Else return:
Didn't found value in DB, CustomerId
How can I do that? Especially in Microsoft compact SQL server limited syntax...
Asked by user29534
(13 rep)
Oct 19, 2013, 04:51 PM
Last activity: Nov 12, 2019, 09:57 AM
Last activity: Nov 12, 2019, 09:57 AM