Free Online Courses for Software Developers - MrBool
× Please, log in to give us a feedback. Click here to login
×

You must be logged to download. Click here to login

×

MrBool is totally free and you can help us to help the Developers Community around the world

Yes, I'd like to help the MrBool and the Developers Community before download

No, I'd like to download without make the donation

×

MrBool is totally free and you can help us to help the Developers Community around the world

Yes, I'd like to help the MrBool and the Developers Community before download

No, I'd like to download without make the donation

How to use the select statements on the correct database - T-SQL Step by Step Course - Lesson 6 | SQL courses

In this video, we will continue the select statement discussion.

Duration: 16:18 min

Summary: In this video, we will continue the select statement discussion. We will start with the ‘use’ statement. We know that when we are writing SQL statements, we can be targeting many databases. So the question is: How can I make sure that my script is running against the right database? If we are lucky and we run the statement against the wrong database, we get an error message. But what happens if both databases have the same table name and you execute the script against the wrong database? No error message, just that what you intended. For this reason, the use statement comes to the rescue. We can put this statement at the top of the script to make sure that whenever we run the script we are ‘using’ the correct database. Then, we will see how to use the ‘order by’ clause to order our result set in ascending and descending order.

Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012, Database, Schema, Table, Select, From, Column, Row, where,Use, Order By, Year, Month, asc, desc.



Senior Software Engineer with experience in C#, JavaScript, jQuery, Knockout JS, Kendo UI, HTML5, and SQL Server. Ayad has more than 20 years experience in technical training and teaching. Contributor to MrBool for about 7 years.

What did you think of this post?
Services
[Close]
To have full access to this post (or download the associated files) you must have MrBool Credits.

  See the prices for this post in Mr.Bool Credits System below:

Individually – in this case the price for this post is US$ 2,00 (Buy it now)
in this case you will buy only this video by paying the full price with no discount.

Package of 10 credits - in this case the price for this post is US$ 1,00
This subscription is ideal if you want to download few videos. In this plan you will receive a discount of 50% in each video. Subscribe for this package!

Package of 50 credits – in this case the price for this post is US$ 0,33
This subscription is ideal if you want to download several videos. In this plan you will receive a discount of 83% in each video. Subscribe for this package!


> More info about MrBool Credits
[Close]
You must be logged to download.

Click here to login