In this tutorial, we’ll look at the set operators used in TSQL. Set operators and Joins work very similar but the biggest difference is that, in set operators, the result set is a superimposed table made out of the two tables used in the select statement. That is, the columns are not repeated, the values from […]
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 […]