Selecting data in SQL videos | SQL Queries Part 7 - Using Functions in Queries

Posted by Andrew Gould on 30 May 2012

Learn the basics of using functions in Microsoft SQL Server queries. This video teaches you how to use functions to create calculated columns in a query, including where to find a list of available functions, how to work out which parameters you need to fill in using the help system, and how to combine functions in more elaborate calculations.

You can increase the size of the video:

Full screen mode for YouTube

You can view the video in full screen mode as shown on the left, using the icon at the bottom right of the frame.

You can also increase the quality of the video:

Changing resolution

You can improve the resolution of the video using another icon at the bottom right of the frame. This will slow down the connection speed, but increase the display and sound quality. This icon only becomes visible when you start playing the video.

Finally, if nothing happens when you play the video, check that you're not using IE in compatibility view.

This page has 2 threads Add post
duggie   Reply to duggieReply
27 Oct 17 at 16:01

Yes, thanks.

 

 

duggie   Reply to duggieReply
27 Oct 17 at 10:34

I have got a copy of the database the accompanies this SQL video.  When I expand Database Diagrams, I don't have anything.  Why is that?

Andrew G   Reply to Andrew GReply
27 Oct 17 at 15:25

For the very simple reason that you can't script the creation of a database diagram! Fortunately, we do have a video which includes a section on creating database diagrams which you can view here https://www.wiseowl.co.uk/videos/sql2016/design-relational-database.htm

I hope that helps!

Add a new post