自动生成数字 [英] Auto Generate Number

问题描述

亲爱的所有人，



我想生成字母数字的自动编号。



我有一个系统设置表，我有字段Imp_Case_Control字符（15）我想在插入按钮上添加自动生成代码。



imp case控制PLHOA0101010101哪个来自从System_Setup中选择Imp_Case_Control



（PLHOA0101010101 + 00001）



--------- ----------------我希望结果显示在表格上

1. PLHOA01010101010001

2. PLHOA01010101010002

解决方案

自定义自动生成的序列与SQL Server [ ^ ]



自定义。

参考



http://forums.asp.net/t/1608233.aspx [ ^ ]



希望这有助于

< blockquote>试试这个链接我希望这对你有帮助.. http://stackoverflow.com/questions/18928870/custom-auto-generated -sequences-with-sql-server [ ^ ]

Dear All,

I want to Generate Auto Number which is alpha numeric.

I have a table of System Setup which I have field Imp_Case_Control Char(15) I want to Add auto generate code on insert button.

imp case Control PLHOA0101010101 Which will comes from select Imp_Case_Control from System_Setup

(PLHOA0101010101+00001)

------------------------- I want result to be displayed on form
1. PLHOA01010101010001
2. PLHOA01010101010002

解决方案

Custom Auto-Generated Sequences with SQL Server[^]

Customize it.

Refer

http://forums.asp.net/t/1608233.aspx[^]

Hope this helps

try this link I hope this is help full for you..http://stackoverflow.com/questions/18928870/custom-auto-generated-sequences-with-sql-server[^]

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