sql server 只有一个自增长列,如何插入值?

 

declare @i int
declare  @tTPID table(tpid int not null identity(1,1) primary key)
declare  @tTUID table(tuid int not null identity(1,1) primary key)
declare  @tPNID table(pnid int not null identity(1,1) primary key)
declare  @tTRL table(trl int not null identity(1,1) primary key)
--declare  @tGAID table(gaid int not null identity(1,1) primary key)
--
--set @i = 1
--while @i < 10 begin
--    insert into @tGAID default values 
--    set @i = @i + 1
--end

set @i = 1
while @i < 10 begin
    insert into @tTRL default values 
    set @i = @i + 1
end

set @i = 1
while @i < 10 begin
    insert into @tTPID default values 
    set @i = @i + 1
end

set @i = 1
while @i < 10 begin
    insert into @tTUID  default values 
    set @i = @i + 1
end

set @i = 1
while @i < 10 begin
    insert into @tPNID default values 
    set @i = @i + 1
end

 

 

深圳A8数据分析处理工作室

咨询热线：

１３７-１４３-４００-９９

 地址：深圳市南山区科技园南区软件园 http://www.HiA8.cn