1 --SQL SERVER中的流水号创建2 create table books
3 (
4 no
int identity(
1,
11),
5 bid
as right(
replicate(
'0',
5)
+ cast(
[no] as varchar),
6),
6 [name] varchar(
50)
7 );
8 insert into books(name)
values(
't1');
转载于:https://www.cnblogs.com/vida/archive/2012/02/29/2373147.html
相关资源：sql 流水号获取代码实例
