Duration: 28:54 min
Summary: In this video, we will talk about paging. If you have done any work with web page technologies, you would know that paging is an important concept. Say you have a grid that displays 500 records. You can load a specific number of records first (say 25) and then the other records will be loaded on demand as the user is moving from one page of 25 items to the next. SQL Server 2012 helps in this regard. This feature has been added to fetch a specific number of records. Then move to the next set as the user demands it. We will see the new syntax to do that.
Then we will discuss the "real" order the select statement is being interpreted and the importance of this order on how some items will / will not work in the where clause.
Finally, we will discuss how to use "in" in a where clause.
Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012, Database, Schema.