How do I use OFFSET and FETCH NEXT?
In this video we’ll walk you though how to use OFFSET and FETCH NEXT. We’ll show you how you can use these clauses to return a portion of your query results, such as 10 rows starting 1000 rows down. OFFSET and FETCH NEXT are similar to TOP, but I believe they are more powerful. Once […]
Continue readingHow do I use the Like Clause in SQL Server?
In this video we’ll walk you though how to use the LIKE clause. We’ll show you how to you can perform partial matches, such as being able to match all names beginning with “B” or ending in “Y.” We’ll also show you how to use use ranges. For instance you may want select all […]
Continue readingReturn the first rows from your result.
In this video we’ll walk you though how to select top rows within a query. We’ll show you how to retrieve the top or bottom rows in the result. We’ll also show you how to use one sort to select the rows, and once completed, another sort to present them (tricky). For instance you […]
Continue reading