Understanding Different Key Types in SQL

In the realm of database design and key classification, there are a total of nine distinct keys to be taken into account. Primary, foreign, and unique keys are typically well-known among SQL developers, as they are implemented through SQL syntax and serve as constraints. However, when undertaking database design, it is important to take into … Continue reading Understanding Different Key Types in SQL

What are the different SQL Server databases used for?

In Microsoft SQL Server, there are several different types of databases that can be created and used for different purposes. Here is a brief overview of some of the most common types of databases in SQL Server and the scenarios in which they are typically used. Databases are categorized into two different types, User and … Continue reading What are the different SQL Server databases used for?

Stored Procedures: Returning Data Using a Result Set

For this article, we are going to examine the benefit of using stored procedures that simply return a result set (i.e. a stored procedure that has a SELECT statement). Before we do a shallow dive into this functionality, it is worth noting that SQL Server has 3 methods of returning data from a stored procedure: … Continue reading Stored Procedures: Returning Data Using a Result Set