Sql server自动生成数字

问题描述:





我正在进行图书馆管理。在这个项目中,我为各个书籍保留了独特的条形码。

所以我必须自动生成条形码。我想生成'AAAAAA','AAAAAB'.......'AAAAAZ','AAAABA',

AAAABB',....这个系列。



我在存储过程中生成此代码并插入表中。怎么做sql server,



有任何想法请帮帮我....

Hi,

I m doing library management. In this project I maintain unique barcode for individual books.
So I have to autogenerate barcode. I want to Generate 'AAAAAA','AAAAAB'.......'AAAAAZ','AAAABA',
AAAABB',.... this series.

I generate this code with in stored procedure and insert into table also. How to do it sql server,

Have any idea please help me....

嗨UshaCbe,



请浏览CodeProject存档 [点击这里] [ ^ ]。它有解决方案。



谢谢,

RelicV
Hi UshaCbe,

Please go through the CodeProject archive [Click Here][^]. It has the solution.

Thank you,
RelicV