？自动增量列的下一个值是记录数 - 而不是最高值+1的错误？ [英] ? bug where autoincrement column's next value is # of records - not highest value +1 ?

问题描述

是否存在已知错误，其中由Sync Services创建的.sdf文件中的自动增量字段没有正确的"下一次自动增量"。值？

Is there a known bug where an auto-increment field in an .sdf file created by Sync Services does not have the correct "next auto increment" value?

当SF创建我的.sdf文件时，下一个自动增量值是记录数...而不是预期的+1列中的最高数字。

when SF creates my .sdf file the next auto-increment value is the number of records ... not the highest number in the column +1 as expected.

推荐答案

检查一下：
http://msdn.microsoft.com/en-us/library/bb726019.aspx

引用：

"标识列从服务器复制到客户端数据库，但标识种子和增量始终分别设置为0和1。这与服务器数据库中的属性设置无关。 SQL Server Compact标识列
的数据类型必须为 int 或 bigint 。 SQL Server Compact标识列的数据类型不能为
smallint ， tinyint ，十进制或
数字即可。有关标识列的详细信息，请

"Identity columns are copied from the server to the client database, but the identity seed and increment are always set to 0 and 1, respectively. This is regardless of how the properties were set in the server database. SQL Server Compact identity columns must have a data type of int or bigint. SQL Server Compact identity columns cannot have a data type of smallint, tinyint, decimal, or numeric. For more information about identity columns"

 

这篇关于？自动增量列的下一个值是记录数 - 而不是最高值+1的错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！