创建表后如何将主键设置为自动增量值 [英] how can set primary key as autoincremented value after created table

问题描述

你好朋友
我正在创建包含primaykey id名称applicationnumber的表.我想做的是我想基于year.net应用程序设置起始号码.但是当我设置起始号码时，它将自动增加它们的值.我该怎么办. br/> 请帮助我.

Hi friends
I am creating table which contain primaykey id name applicationnumber.what i want to do is I want to set starting number from .net application based on year.but when i set starting number then it automatically increment their value.How can i do.
please help me.

推荐答案

使用您自己的号码启动IDENTITY列:

Start an IDENTITY column with your own number: It''s called the seed.

这篇关于创建表后如何将主键设置为自动增量值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！