Search results
06/25/2013
Video tutorial
Views - T-SQL Step by Step Course - Lesson 20
In this video, we will talk about views. SQL Server books online define a view as follows: "A view can be thought of as either a virtual table or a stored query."
06/25/2013
Video tutorial
Subqueries - T-SQL Step by Step Course - Lesson 19
Today, we will talk about subqueries, which are queries within queries. The outermost query is a query which resultset is returned to the caller. It is known as the outer query.
06/19/2013
Video tutorial
Insert, Update and Delete - T-SQL Step by Step Course - Lesson 17
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.