SQL流水号

--SQL SERVER中的流水号创建
create table  books
(
no int identity(1,11),
bid as right(replicate('0',5) + cast([no] as varchar),6),
[name] varchar(50)
);
insert into books(name) values('t1');