22,209
社区成员
发帖
与我相关
我的任务
分享
----------------------创建环境
create table TB_test
(
id int identity(1,1),
Item nvarchar(30)
)
insert TB_test select 'A'
select * from TB_test--查看
----------------------开始设置自动id为17
create table table_t
(
id int,
Item nvarchar(30)
)
insert table_t select * from TB_test
truncate table TB_test
declare @n int
select @n=(ident_current('TB_test'))
while @n<17
begin
select @n=@n+1
insert TB_test select 'B'
end
delete TB_test
insert TB_test select Item from table_t
select * from TB_test--查看
-------------------------------------删除环境
drop table table_t
drop table TB_test