2
Create a Pivot table in six steps to cross tabulate your data
In this episode of SQL Minute I want to share with you how to create a pivot or cross tab chart. I’ll show you the steps using an example from the adventure works database. I get so many questions on how to create these! Once you get the steps down, you’ll see they are not […]
Continue reading
2
How to use the Choose Function with Select
In this video we’ll walk you though how to use the CHOOSE function with SELECT. You’ll see how the function works and then a practical example using some sample data. Once you’ve gone through this article, I would recommend watching our next Essential SQL Minute to continue learn more about SQL Server! Once you have […]
Continue readingCommon Data Types used in SQL Server
In this video we’ll walk you though the common data types used in SQL Server; you’ll see examples of each type’s values, and how to define them. Once you’ve gone through this article, I would recommend watching our next Essential SQL Minute to continue learn more about SQL Server! Once you have watched the video […]
Continue reading
3
How to include a single quote in a SQL query
In this video we’ll walk you though how to include a single quote in a SQL query; we’ll show how to escape the single quote, so it is treated as text rather than text delimiters. Once you’ve gone through this article, I would recommend watching our next Essential SQL Minute to continue learn more about […]
Continue reading
2
How to use the IN Operator with a SubQuery
In this video we’ll walk you though how to use the IN operator with a Subquery; we’ll show you why you would want to use IN with a subquery. In it’s simplest form the IN statement matches a column values to a list. TRUE is returned if there is a match. A main advantage of […]
Continue readingHow to use the IN operator with an Expression List
In this video we’ll walk you though how to use the IN operator; we’ll show you why you would want to use the IN operator and how to avoid some pitfalls associated with NULL. The IN operator matches a column to a list. Once you’ve gone through this article, I would recommend watching our next […]
Continue readingHow to use the BETWEEN operator to compare a range of values in SQL SERVER Queries
In this video we’ll walk you though how to use the BETWEEN operator; we’ll show you why you would want to use the BETWEEN operator and how to avoid pitfalls when using it with the DATETIME type. The BETWEEN operator is equivalent to using AND combination of >= and <= comparison operators, but makes for […]
Continue readingHow 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