Reading Time: 6 minutesStored 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
Josh D
SQL Server CONVERT: A How-To Guide with Examples
Reading Time: 7 minutesThe 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 minutesThere 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
SQL Server REPLACE: Explained
Reading Time: 4 minutesThe SQL Server REPLACE function is a very simple system function that is built into Microsoft SQL Server. It is one of the best tools you can use for string manipulation in SQL Server. In this very brief tutorial, we’ll discuss the SQL Server REPLACE function and how to use Continue Reading
SQL Server DATEDIFF System Function: Explained
Reading Time: 6 minutesThe SQL Server DATEDIFF system function is a very useful function for manipulating date information in your database. In this very brief tutorial, we’ll discuss how the DATEDIFF function works and the key topics you should know when working with this function. Here is what we’ll discuss: The syntax of Continue Reading
SQL Server DATEADD System Function: Everything you need to know
Reading Time: 6 minutesMicrosoft SQL Server has several built-in system functions to help you calculate date information very easily. One of those helpful functions is called DATEADD. In this very brief tutorial, we’ll discuss everything you need to know about the DATEADD system function and give you examples of how to use it. Continue Reading
How to change a column type in SQL Server
Reading Time: 7 minutesSQL Server makes it very easy to change the data type of a column. Maybe you need to make a column larger, or maybe you want to make your table slightly more efficient. Through the ALTER COLUMN statement, we can very easily change a column’s data type. In this very Continue Reading
SQL Server Default Constraint: A Guide for Beginners
Reading Time: 6 minutesIn Microsoft SQL Server, one of the things we should always keep in mind is the integrity of our data. One of the best ways to maintain data integrity is to introduce constraints into our tables. Constraints are a great way to restrict the data that can be inserted into Continue Reading
SQL Server Check Constraint: Full Beginner-Friendly Tutorial
Reading Time: 11 minutesWhen working with SQL Server databases, one of the most important things we should always keep in mind is the integrity of our data. We should do our best to make sure the data in our database is valid. One of the best ways we can accomplish this is through Continue Reading
How to escape a single quote in SQL Server
Reading Time: 2 minutesSQL Server makes it very easy to escape a single quote when querying, inserting, updating or deleting data in a database. Here’s how it’s done: Just use another single quote For example, let’s take a look at a table called Books: Let’s say we want to insert another row for Continue Reading