SQL Server 自动生成编号
- 新建表
(
number
varchar(20)
)
2.自动生成编号
use table
ceshi
declare @x int
select
@x =1
while
@x<=1
begin
insert
into
three
(number)
values
('a'+cast
@x
as
varchar)
select
@x=@x+1
end