Sample Header Ad - 728x90

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