SQL SERVER – Basics Video: Running SQL Code – SQL in Sixty Seconds #057

10 years ago

This is the 2nd post out of my 10 post series of my videos on my 10th book – SQL Basics Video: Running SQL Code. Today will show the importance of data and information.

You can get that in Paperback (USA) and Kindle (Worldwide).

When we run the SQL code, it is often a series of SQL statements created by someone else. Still, we are often tasked with adding to the code to customize it for our system or testing the code and making suggestions. For this reason, the SQL Admin must know basic SQL coding skills. This section will focus on the most common types of queries. If being great at all types of queries is important to you, then we recommend a deeper study with the Joes 2 Pros SQL Queries series starting with Volume 1 for beginners and work through to Volume 5.

Of course, as shown in the two earlier queries in the video, we can put square brackets around any table. In fact, the code generated automatically by SQL Server always creates these delimiters for every object in the database. The only time we must use the square bracket delimiters is when table names are separated by a space, have the same name as a SQL Server keyword (bad idea), or are otherwise named in a way that is not obvious or easily interpreted by SQL Server.