Reading Time: 16 minutesWindow functions in SQL Server are very powerful tools we can use to gather meaningful information from our database. Window functions are considered an advanced tool when querying data in SQL Server. If you’re trying to learn about window functions, congratulations, you’re moving up! Do you need to understand how Continue Reading
SQL Server Custom Data type: A How-To Guide
Reading Time: 5 minutesOne of the more interesting things you can do within Microsoft SQL Server is create your own custom data type. The process is actually very simple. In this very brief tutorial, we’re going to learn how to create a custom data type in SQL Server. We’ll discuss these topics: The Continue Reading
Need a SQL Server Boolean value? Use the BIT data type!
Reading Time: 6 minutesWhen creating a table or database object in SQL Server, there are definitely instances where you will need to store a Boolean value (aka true or false). But is there such a thing as a SQL Server Boolean? In SQL Server, there is absolutely a data type we can use to Continue Reading