1 --SQL SERVER中的流水号创建2 create table books3 (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');