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 […]
In this lesson, l want to briefly go over how to perform search using a wild card. The symbol used for wild card is the percent sign (%). Lets see how this is used to perform searches. Assume we have a table called person that has person id, first name and last name columns. Then […]