eg:Create Table TEST (ID Int Identity(1,1), Name Varchar(10))
create table tb1(sn int identity(1,1),name1 char(8));
create table t(id int identity(1,1),code varchar(4)) insert into t(code) select 'AAAA' insert into t(code) select 'BBBB' insert into t(code) select 'CCCC' goselect * from t godrop table t
create table t(id int identity(1,1),code varchar(4)) insert into t(code) select 'AAAA' insert into t(code) select 'BBBB' insert into t(code) select 'CCCC' goselect * from t /* id code ----------- ---- 1 AAAA 2 BBBB 3 CCCC */ godrop table t go
(ID Int Identity(1,1),
Name Varchar(10))
insert into t(code) select 'AAAA'
insert into t(code) select 'BBBB'
insert into t(code) select 'CCCC'
goselect * from t
godrop table t
insert into t(code) select 'AAAA'
insert into t(code) select 'BBBB'
insert into t(code) select 'CCCC'
goselect * from t
/*
id code
----------- ----
1 AAAA
2 BBBB
3 CCCC
*/
godrop table t
go