• Product Documentation for Microsoft SQL Server Code-Named “Denali” CTP3 (link);
  
• Express Core CTP 3 (link);
  
• PowerPivot for Microsoft Excel CTP 3 (link);
  
• Semantic Language Statistics CTP 3 (link);
  
• Report Builder CTP 3 (link);
  
• Reporting Services Add-in for SharePoint Technologies CTP 3 (link).
  

Постановка задачи

• Offset (смещение)
• Fetch First или Fetch Next (взять первые… или взять следующие…)

Offset

Select *
From  <SomeTable>
Order by  <SomeColumn>
Offset 10 Rows

Create Table WithOutSequence1
(
	 EmpId int identity not null primary key
	,EmpName varchar(50) not null
)

Insert into WithOutSequence1
	Select 'Violet' Union All
	Select 'Tape'

Select * from WithOutSequence1

Create Table WithOutSequence2
(
	 EmpId int identity not null primary key
	,EmpName varchar(50) not null
)

Insert into WithOutSequence2
	Select 'Violet' Union All
	Select 'Tape'

Select * from WithOutSequence2

CREATE SEQUENCE [schema_name . ] sequence_name
[ AS { built_in_integer_type | user-defined_integer_type } ]
| START WITH <constant>
| INCREMENT BY <constant>
| { MINVALUE <constant> | NO MINVALUE }
| { MAXVALUE <constant> | NO MAXVALUE }
| { CYCLE | NO CYCLE }
| { CACHE [<constant> ] | NO CACHE }