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