摘要：
USE [Tmp]GOCREATE TABLE [dbo].[HolidayName]( [ID] [tinyint] NOT NULL, [Name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,CONSTRAINT [PK_HolidayName] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_IN... 阅读全文
摘要：
http://www.cnblogs.com/gjahead/archive/2007/04/04/699842.html 阅读全文
摘要：
--sql 2000select * from(select * ,number = (select count(*) from tb where id t.id) + 1 from table t) m where number = 你指定的数值.--sql 2005select * from(select * , number = row_number() over(order by id) from table ) m where number = 你指定的数值. 阅读全文