I am trying to port over from SQL Server 2005 Express
to > SQL Server CE 3.5 SP1
(sql 2008 Commands mabee?)
Want to use a query internal to Visual Studio 2008's Query
Here is How the code looks in the Query Window of VS 2008 VB... Do NOT wan't to use Linq...!
SELECT [Record Number], Date, Car, Miles_Start, Miles_Stop, Gallons_FillUp, Miles_Stop - Miles_Start AS Miles_Total, (Miles_Stop - Miles_Start) / Gallons_FillUp AS MPG
ORDER BY Car, Date DESC
It processes fine but does not work: Just Want to Preform Basic math on the Data Table. Add, Subtract, Devide and Multiply.
In the "Advanced Options" of Query Builder the " Refresh The Data Table" Is greyed out...
Any Ideas where I can get a good command reference or PDF
Book on SQL Server Compact Edition 3.5 sp1 ?
Any and all help would be appreciated!