生成序列号 [英] Generating sequence number

问题描述

我正在使用C#在ASP.Net上工作，我想生成一个应该像这样的序列ID:

I am working on ASP.Net using C# I want to generate a sequence id that should be like this:

ELG0001 , ELG0002, ...

ELG是PREFIX，并且应该按顺序0001.

我正在使用sql server2005.将生成此ID，并将其添加到我的数据库中.

ELG is the PREFIX and 0001 should be in sequence.

I am using sql server 2005. This id will be generated and added to my database. how can i do?

推荐答案

选项1:
在您的数据库中创建一个ID字段.保持它为Integer类型，并每次自动递增1. (设置表时，可以很容易地在DB中完成！)

现在，它只是固定的字母"ELG"，请在需要时在查询中获取数据时附加它们，或者在UI中在适合您的地方使用UI时附加它们.

选项2:
在数据库中创建一个ID，TempID字段.将ID字段保留为nvarchar(10)类型，将TempID字段保留为Ineger类型，并自动递增1.

现在，在将记录插入表时:

OPTION 1:
Create an ID field in your database. Keep it as Integer type and auto-increment by 1 each time. (this can be done in DB very easily while setting up a table!)

Now since, its just the fixed letter ''ELG'', append that whenever you are using them either in query while fetching data or in UI while using it whereever suits you.

OPTION 2:
Create an ID, TempID field in your database. Keep ID field as nvarchar(10) type and TempID field as Ineger type and auto-incrementable by 1.

Now, at the time of inserting record in table:

1.您可以在ID字段中插入"ELG" + TempID.
2.或您可以使用TRIGGER插入值

1. You can put up on ID field that insert "ELG"+TempID.
2. OR You can use TRIGGER to insert value

对于有序号，您可以具有自己喜欢的任何逻辑.您甚至可以从前端传递它.

For having sequential numbers, you can have any logic you like. You can even pass it from frontend.

这篇关于生成序列号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！