In this tutorial, l’m going to touch on one of the most common statements you’ll see on daily basis when writing sql in real time programming environment. Joins are used for combining multiple tables based some similarities among those tables. During normalization, some tables may be broken down into two or more tables in order to have […]
System functions are inbuilt functions that can be used to perform some tasks without writing code to perform the task. There are lot of system functions but l’m going quickly over just couple of them. –Date/Time functions –static dates are stored as ‘yyyy-mm-dd’ There are many date formats but l’m just dealing with one basic […]
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 […]