Welcome everyone to the T-SQL course. Here you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2012 (which is a free download). As a sample, we will use AdventureWorks 2012 as our database. Along the way, we will be creating our own sample databases to illustrate some key points. But AdventureWorks 2012 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
In this video, we will discuss the use of the ‘percent’ keyword, also we will talk about the use of ‘with ties’ when using ‘top’ and what effect it will have on the result and finally we will see the use of comments (single line and multi-line comments).
In this video, we will shift from the select statement to data modifications. After all, T-SQL gives the user the ability to change data in the tables. Sometimes, we need to update a person’s address, or remove a customer that does not exist.
In this video, we will discuss the output clause and the merge statement. SQL Server Books Online defines the output clause as: Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement