What is new in SQL Server 2012 : Sequence

create sequence MySeq as int
    start with 1  — Start with value 1
    increment by 1– Increment with value 1
    minvalue 0 — Minimum value to start is zero
    maxvalue 10 — Maximum it can go to 100
    no cycle — Do not go above 100
    cache 5 — Increment 5 values in memory rather than incrementing from IO

select next value for dbo.MySeq as seq_no;

What is new in SQL Server 2012 : OFFSET, FETCH

This is a new feature in SQL Server 2012. It allows the user to skip certain number of rows and return a certain number of rows. This feature is very useful in paging.

— The following query skips the first ten rows and return the following 6 rows:
select * from
transactions order by transaction_id
offset 10 rows
fetch next 6 rows only

— The following query returns the first 6 rows:
select * from
transactions order by transaction_id
offset 0 rows
fetch first 6 rows only

— The following query returns all the rows
select * from
transactions order by transaction_id
offset 0 rows

— The following query skips first ten rows and return all the other rows
select * from
transactions order by transaction_id
offset 10 row

Note:
You can use next and first interchangeably. Similarly rows and row also can be used interchangeably.