Reading Time: 6 minutes Two of the most helpful objects you can create in Microsoft SQL Server are user-defined functions and stored procedures. If you are just starting out with SQL Server, you might wonder “What’s the difference?“. In this very brief tutorial, we’ll discuss the difference between SQL Server functions and stored procedures Continue Reading
Functions
The ONE skill you should have if you want to be a Database Developer
Reading Time: 9 minutes If you want to get into the fields of database development, database administration or data science, there is one skill you should have that will give you an advantage and make it easier to learn the tools necessary to do your job. This is a skill most database professionals already Continue Reading
SQL Server Table Expressions: The Ultimate Guide for Beginners
Reading Time: 10 minutes There are several different kinds of table expressions you need to be aware of when learning to query and develop SQL Server databases. Each kind of table expression has it’s own strengths and weaknesses, and it is important for you to understand those strengths and weaknesses so you know which Continue Reading
User Defined Functions in SQL Server: A Complete Guide
Reading Time: 11 minutes In this introduction tutorial, we will discuss one of the most common SQL Server objects you will see in your career working with SQL Server: User defined functions. There are three types of user defined functions in SQL Server: Scalar Valued Functions Inline Table Valued Functions Multi Statement Table Valued Continue Reading
Multi Statement Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 12 minutes One of the most powerful tools available to us in Microsoft SQL Server is Multi Statement Table Valued Functions. These are user-defined functions similar to Scalar functions and Inline Table Valued functions. We use functions in SQL Server to run repeatable code very easily. Are you struggling to understand how Continue Reading
Inline Table Valued Function: The Ultimate Guide for Beginners
Reading Time: 9 minutes In this tutorial on SQL Server user defined functions, we will discuss Inline Table Valued Functions. User defined functions are an extremely common thing in Microsoft SQL Server. A solid understanding of user defined functions is crucial for anyone who is in the position of querying and developing SQL Server Continue Reading
Scalar Valued Function: The Ultimate Guide for Beginners
Reading Time: 10 minutes User defined functions are very common objects you will see and use when querying and developing SQL Server databases. It is very important that you know what they are and how they work. In this first lesson on SQL Server user defined functions, we will discuss Scalar Valued Functions. If Continue Reading