Sequence Object : User created objects for generating sequence numbers with specified increments
/* Creating Sequence */
CREATE Sequence MySequence
Start WITH 1
Increment BY 1;
INSERT MyTable (ID, Name)
VALUES (NEXT VALUE FOR MySequence, ‘asdf’),
(NEXT VALUE FOR MySequence, ‘qwer’)
Extended full text index : Full text index has been extended , which will allow us to search and index from data stored in metadata and extended properties. Properties like file type, created date etc of an external files can be brought into the index.
Query Paging : This is a long waiting feature from SQL server . This is accomplished by extending the ORDER BY statement.
SELECT SaleOrderID, ItemCode, Qty
ORDER BY SalesOrderID
OFFSET 100 ROWS
FETCH NEXT 100 ROWS ONLY;
Offset will give an indication about how many rows it has to take at first and the FETCH part will tell about how much records it has to return each time.