sqlÓï¾ä²éѯ±íµÄ×Ö¶ÎÃû

select name from syscolumns where id in (select id from sysobjects where type = 'u' and name = 'ÏàÓ¦±íÃû')  
ÓÃÒÔÉÏsqlÓï¾äÊäÈëÏàÓ¦±íÃû¾Í¿ÉÒԲ鵽±íµÄ×Ö¶ÎÃû£¬¶ÔÓ¦ºÃÊý¾Ý¿â ²éѯÊÇ·ñ´æÔڸñíÓï¾ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tb_cost]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tb_cost]
GO
´´±íÓï¾ä
CREATE TABLE [dbo].[tb_cost] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[inputtime] [datetime] NOT NULL ,
[pushcount] [int] NOT NULL ,
[revertcount] [int] NOT NULL ,
[revertrate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[unitprice] [float] NOT NULL ,
[cost] [float] NOT NULL ,
[income] [float] NOT NULL ,
[rate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[pushinfor] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
½¨Ë÷Òý½Å±¾£º
create clustered index Ë÷ÒýÃû on ±íÃû(±í.×Ö¶Î)
ÔÚ±íÔö¼ÓÒ»¸ö×ֶΣ¬ÀýÈçfa×Ö¶Î
alter table ±íÃû add fa int not null default 0
Ñ¡ÔñÇ°Ãæ m-n ÌõÊý¾ÝµÄÓï¾ä
ÀýÈçÑ¡ÔñÇ°ÃæµÚ 5-10£¨m=10£¬n=5£© Ìõ¼Ç¼µÄsqlÓï¾äÈçÏ£º
sql="select top 6 * from table where (id not in (select top 4 id from table order by id desc)) order by id desc"
ÆäÖÐ6£¬4 ÊÇÕâÑùµÃÀ´µÄ
sql="select top m-n+1 * from table where (id not  in (select top n-1 id from table))