Mr_ChenZheng的博客

使用ALTER TABLE语句创建索引 alter table table_name add index index_name (column_list) ; alter table table_name add unique (column_list) ; alter table table_name add primary key (column_list) ; 删除索引 drop index...

查询前几条的四种方法 <!--第一种--> select top(10)* from AdminInfo where Id not in(select top(10) Id from AdminInfo) <!--第二种--> select top(10) * from AdminInfo where Id>(select MAX(Id)from AdminInfo...