In today’s discussion, I’m focusing on one important component of T-SQL, that is sub queries. As the name implied, a sub query is simply a query that is made up of outside query and inside query. This means, one query is embedded inside another query. The are two types of sub queries, regular sub queries and […]
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 […]