在现有数据库中添加标识列 [英] Add a identity column in existing database

问题描述

大家好



我有一张包含大约7000多种数据的表格。



现在我想要在现有数据上添加唯一的id列，以后如果用户添加

任何记录，它应该自动增加。



例如以下是现有数据

Hi all

I have a table which contains around 7000+ data.

now i want to add a unique id column on the existing data and also later if user adds
any records, it should increment automatically.

e.g. Below is the existing data

1    name    54
1    name    50
2    age     88
3    place   12....

我想要这样

and i want like this

00001   1    name    54
00002   1    name    50
00003   2    age     88
00004   3    place   12....

请告诉我怎么做这个



对不起，我做了一个错误的标签。

我在谷歌搜索，我得到了一个名为serial的自动增量ID，这符合我的目的。



但有一件事我希望这个数字像这样开始 - 00000000001等等。

Please tell me how to do this

I am sorry, i made a wrong tag.
I search in google and i got something called "serial" for auto-increment id which serves my purpose.

But one thing i want the number to start like this-"00000000001" and so on.

推荐答案

您没有提供有关您的问题的足够信息。因此，我认为最困难的是创建自定义自动生成序列，例如： 00001 。



请按照下列步骤操作： http://www.sqlteam.com/article/custom -auto-generated-sequences-with-sql-server [ ^ ]

You did not provide enough information about your issue. So, i assume that the most difficult to you is to create custom autogenerated sequence, for example: 00001.

Follow these steps: http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server[^]

这篇关于在现有数据库中添加标识列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！