什么是“身份" [英] What is theMeaning of 'Is Identity'

问题描述

在ASP.NET中工作.

在"Table.Colum"中设计一个新的SQL数据库时，我得到了要填写的条目"IsIdentity?"，这意味着什么，将其设置为"FALSE"的长期后果是什么? ''或``TRUE''


问候，


Bram:)

Working in ASP.NET.

In designing a new SQL Database,in ''Table.Colum'' I get the Entry to be Filled in, ''IsIdentity?'' What does this mean, and what are the long term consequences of setting it to either ''FALSE'' or''TRUE''


Regards,


Bram :)

推荐答案

好吧，我想您只是为了自己的工作而工作，而不是在工作吗?

标识列是自动生成的.您可以指定起始索引和每次添加的数量，通常分别为1和1，因此在插入数据时，您无法指定这些值，它们只会自动递增.因此，从长远来看，您将获得一个ID，该ID可以唯一标识每条记录，而您无法更改或设置该记录.

http://www.sqlteam.com/article/understanding-identity-columns [ ^ ]

OK, I assume you''re just working for your own pleasure and not at work ?

An identity column is one that is auto generated. You specify the starting index and the amount to add each time, typically these are 1 and 1, so when you insert data, you can''t specify these values, they just auto increment. So, the long term result is, you have an id that uniquely identifies each record, which you cannot ever change or set.

http://www.sqlteam.com/article/understanding-identity-columns[^]

这篇关于什么是“身份"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！