--里面有没有自增字段,如果没有的话 alter table tablename add FID int identity(1,1) delete tablename where FID<=300 alter table tablename drop column FID --如果有自增字段,则根据该字段顺序判断即可
--里面有没有自增字段,如果没有的话 alter table tablename add FID int identity(1,1) delete tablename where FID<=300 alter table tablename drop column FID --如果有自增字段,则根据该字段顺序判断即可
from (select top 300 * from _data) as a
where _data.Key = a.Key
alter table tablename add FID int identity(1,1)
delete tablename where FID<=300
alter table tablename drop column FID
--如果有自增字段,则根据该字段顺序判断即可
alter table tablename add FID int identity(1,1)
delete tablename where FID<=300
alter table tablename drop column FID
--如果有自增字段,则根据该字段顺序判断即可