Sql-server – SQL Server compact- Query that return 2 constant columns even if query didn’t return data

sql serversql-server-compactt-sql

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…

Best Answer

Derived tables and Case statements are supported in SQL CE, so you can use this script

Select 
case 
when s.custs = 0 then 'Didnt found value in DB'
else 'found value in DB'
end
,'customer id'
from 
(select COUNT(*) as 'custs' from Customers c Where  c.CustomerId = 1234) s

for reference check what can and what cannot be used in SQL CE

Related Solutions

SQL Server 2008 – T-SQL Table Valued Function to Split a Column on Commas

Re-worked it slightly...

DECLARE @FoundIndex INT
DECLARE @ReturnValue VARCHAR(MAX)

SET @FoundIndex = CHARINDEX(@delimiter, @String)

WHILE (@FoundIndex <> 0)
BEGIN
      SET @ReturnValue = SUBSTRING(@String, 0, @FoundIndex)
      INSERT @SplitValues (Asset_ID) VALUES (@ReturnValue)
      SET @String = SUBSTRING(@String, @FoundIndex + 1, len(@String) - @FoundIndex)
      SET @FoundIndex = CHARINDEX(@delimiter, @String)
END

INSERT @SplitValues (Asset_ID) VALUES (@String)

RETURN

Sql-server – Options for keeping two SQL Server Compact databases in sync

From the development perspective, you could try the Microsoft Sync Framework.

For further information about Microsoft Sync Framework, refer to the following links:

Best Answer

Related Solutions

SQL Server 2008 – T-SQL Table Valued Function to Split a Column on Commas

Sql-server – Options for keeping two SQL Server Compact databases in sync

Related Question