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....