Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes with the video. See Also Additional Training on my YouTube Channel Free SQL Query Training 70-461 …
Here is a quick video tutorial on how to use the T-SQL CASE function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample or demo code from the video tutorial. More Info: Additional Training on my YouTube Channel Free SQL Query Training …
>>> Try our JOIN Types Course Today! After learning the INNER JOIN when querying SQL Server, the LEFT OUTER JOIN and RIGHT OUTER JOIN are often what people attempt to learn next. The reason that I say attempt is that most people don’t get OUTER JOINs right the first time they learn it. This becomes very clear when interviewing developers and …
Here is a short video tutorial that shows how to use the CHOOSE function in T-SQL on SQL Server 2012, SQL Server 2014 or Newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code that goes along with the CHOOSE function training. This sample code has been tested and confirmed …
Here is a short video tutorial that shows how to use the COALESCE function in T-SQL on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the first sample code from the video: And then the code that shows the performance differences: More Info: Additional Training on my YouTube Channel …
Here is a quick video tutorial on how to use the IIF function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code from the video. More Info: Additional Training on my YouTube Channel Free SQL Query Training
>>> Try our JOIN Types Course Today! The INNER JOIN has to be the most common JOIN type in SQL Server. This is where we will start on our journey to understand all the JOIN types in SQL Server. The best way that I have discovered to represent JOINing tables is to use Venn Diagrams that show what overlaps, what …
In this presentation we will be training on TSQL Functions, there will be three sections. Date and Time Functions Logical Functions User Defined Functions Here is the link to the Google On Air Broadcast where you can watch live (or recorded later) for free. https://plus.google.com/events/cb0pj9ghp5elt6i241kstphcvr0 Here are the slides. And here is the broadcast at YouTube: This session will be …
You can use the TSQL DATEPART function to extract individual parts of the date from a date or time item. For instance: Will return the following output: The second parameter is the date/time element which can be any of these types: time, date, smalldatetime, datetime, datetime2, or datetimeoffset. Lets take a look at the possible options for the first …
So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and I keep it posted on the wall at the office. This way when I am trying to explain JOIN types, …