identity increment 中文意思是什麼

identity increment 解釋
標識值增量
  • identity : n. 1. 同一，一致；同一性。2. 本體；正身；個性。3. 【邏輯學】同一性。4. 【數學】恆等（式）。
  • increment : n. 增額，增值，增長；【數學】增量；利潤。 unearned increment 【經濟學】自然增值。 increment value duties 增值稅。
  1. Identity seed property and an increment identity increment

    屬性） ，並確定要添加到種子上的增量（
  2. Is not given, the identity values for this column in the data file being imported are ignored, and sql server 2005 automatically assigns unique values based on the seed and increment values specified during table creation

    ，則將忽略被導入的數據文件中此列的標識值，而且sql server 2005將根據創建表期間指定的種子值和增量值自動分配唯一值。
  3. When you add identifier columns to existing tables, the identity numbers are added to the existing rows of the table, with the seed and increment values applied starting with the order in which those rows were originally added

    當您向現有表中添加標識符列時，還會將標識號添加到現有表行中，並按照最初添加這些行的順序開始應用種子值和增量值。
  4. When you add identifier columns to existing tables, the identity numbers are added to the existing rows of the table, with the seed and increment values applied beginning with the order in which those rows were originally added

    當您向現有表中添加標識符列時，還會將標識號添加到現有表行中，並按照最初添加這些行的順序開始應用種子值和增量值。
  5. If keepidentity is not specified, the identity values for this column are verified but not imported and the query optimizer automatically assigns unique values based on the seed and increment values specified during table creation

    如果不指定keepidentity ，則將驗證但不導入此列的標識值。查詢優化器將根據創建表時指定的種子值和增量值自動分配唯一值。
  6. Increment is the incremental value added to the identity value of the previous row that is loaded

    增加到上一個加載行的標識值的增量值。
分享友人
分享到 Line

分享到臉書