Wednesday, October 12, 2005

Now, it bites...

There is one nifty trick I can no longer do in SQL Mobile - writing to an IDENTITY column. I just hope this is Beta behavior, otherwise it will break my products.

SQL CE 2.0 allowed consumers to write on IDENTITY columns, a feature that enables copying desktop databases. The table is created on the device with the IDENTITY column set at the given seed and increment. When copying the table data, the column values are forced (the OLE DB provider complains mildly) and the resulting table behaves exactly like the source one. Interestingly, both Jet and SQL Server allow this so why wouldn't SQL Mobile allow it as well?

1 comment:

weblogz said...

Dell Takes a Serious Blogging
"When [a] company has good news, customers will turn to the bloggers they already trust for interpretation," according to a white paper from Web search and navigation consultancy Intelliseek.
Hi you've got a great blog here, the best I've seen so far for Online loans - apply for loans online related. Keep up the good job! I found a similar Online loans - apply for loans online related website yesterday, check it out. Looks like the
Online loans - apply for loans online related site does not have a blog yet, so check them out at their company site.