Aggregate functions are in built functions that sql server uses to perform some basic tasks. If you need a more complex function to perform a task, then you have to write a user defined function for your operations. l’ll be talking about functions later in the tutorial. Ok, let’s take a look at the Aggregate […]
I want to quickly go over the 3 main control structures in TSQL in this tutorial. Control structures are structures that help us control how we want our program to run based on different situations. Let’s take a look at the Structures one at a time. The IF: This structure controls which path to take […]
One very beautiful feature of sql is the dynamic nature. Dynamic sql referes to code/script which can be used to opereate on different data-sets based on some dynamic values supplied by front-end applications. Imagine you are on a website like 2smart4school and you enter some comments in the form below. What do you think happens to the […]
I’m going to discuss what variables are in TSQL and how to use them. First of all, if you have ever programmed, then you already know what a variable is. It’s just anything that can store data for you. Assume you have to process lot of information and you want a way to carry this […]
