那改成bigint
再不行就用字符型呗select identity(INT,1,1) as id,'9'+right('000000000'+cast(id as varchar(10)),9) as xh into #temp1 from sysobjects
select * from #temp1
再不行就用字符型呗select identity(INT,1,1) as id,'9'+right('000000000'+cast(id as varchar(10)),9) as xh into #temp1 from sysobjects
select * from #temp1
drop table #temp1
select identity(INT,1,1) as iid into #temp1 from sysobjects
select '9'+right('000000000'+cast(id as varchar(10)),9) as xh from #temp
用numeric也可以select identity(numeric,9000000001,1) as xh,* into #temp from table