Reading Time: 8 minutes The SQL Server EXISTS predicate is a very handy tool we can use when querying SQL Server databases. Do you need to know how EXISTS works? You’ve come to the right place! In this very brief tutorial, we’ll discuss how the EXISTS predicate works and provide examples of how to Continue Reading
Correlated Subqueries: A Beginner’s Guide with Examples
Reading Time: 8 minutes There are many very helpful querying tools available to us in Microsoft SQL Server. One of the more complicated querying tools to understand is correlated subqueries. If you are new to SQL Server, I would understand if you simply don’t “get” correlated subqueries. They are a bit strange to wrap Continue Reading
Are you making these 3 mistakes in your stored procedures?
Reading Time: 6 minutes Stored procedures are a major part of any SQL Server database. They are the tools we use to introduce programming logic into our databases, and allow us to repeatedly run complex code. If you are new to SQL Server, you should definitely focus much of your learning towards understanding how Continue Reading
SQL Server CONVERT: A How-To Guide with Examples
Reading Time: 7 minutes The SQL Server CONVERT function is an extremely handy tool to know when it comes to querying SQL Server databases. CONVERT is a system function we can use to very easily convert a value from one data type to another on-the-fly. In this very brief tutorial, you’ll learn everything you Continue Reading
What’s the difference between VARCHAR and NVARCHAR? Answered!
Reading Time: 3 minutes There are four character string data types in Microsoft SQL Server. They are: CHAR NCHAR VARCHAR NVARCHAR You should definitely choose the best character string data type to suit your needs. But you might look at VARCHAR and NVARCHAR and wonder, what’s the difference? Well, in this very brief tutorial Continue Reading