A varChar K varChar B varChar X varChar C varChar id varChar (200开始) D varChar E varChar F varChar
WHAT FIELD IS TABLE1'S KEY? IF IT IS FIELD NAMED "KEYFIELD",TRY:insert into table2(A,B,ID) select A,B,200+(SELECT COUNT(*) FROM TABLE1 WHERE KEYFIELD<A.KEYFIELD) AS ID from table1 A
select A, B, identity(int,1,1)as id into #t1 from table1insert into table2 select A, B, id+199 from #t1
id不是字增型,而且要从200开始,怎么写呢?Table1 Table2
A varChar K varChar
B varChar X varChar
C varChar id varChar (200开始)
D varChar
E varChar
F varChar
IF IT IS FIELD NAMED "KEYFIELD",TRY:insert into table2(A,B,ID) select A,B,200+(SELECT COUNT(*) FROM TABLE1 WHERE KEYFIELD<A.KEYFIELD) AS ID from table1 A