我可以有两个“身份"列吗? [英] Can I have two Identity columns?

问题描述

我可以有两个身份"列吗?如果没有，请解决以下问题.

我有两列需要自动递增.一个(ID)从1开始，另一个(用户名)在sql server 2005中为1000.

Can I have two Identity columns? If not, please solve below problem.

I have two columns I need to auto-increment. One(ID) starts at 1, the other(username) at 1000 in sql server 2005

推荐答案

我不相信您可以有两个Identiy列.但是，您可以将用户名设置为计算列，或将其自动填充到触发器中.

I don''t believe you can have two Identiy columns. But you can make the username a computed column, or fill it automaticly in a trigger.

每个表只能有一个标识列.您可以使用触发器来模拟自动增量列.

You can only have one identity column per table. You can simulate an auto-increment column by using a trigger.

这篇关于我可以有两个“身份"列吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！