I need to setup a SQL Server database on a server with a couple of handheld windows mobile devices.
Some of the updates will be done on the server and some of it on the Windows Mobile devices.
Is there any option to do database synchronization so that all the data be up to date on the server and mobile devices without consuming too much bandwidth.
It will sometimes be done using Wi-Fi and other times 3g / HSDPA.
Synchronisation is more flexible and will synchronize the data at the state it is in, not the 30 tranactions that took it to bring it there.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.