Welcome to the second post in our series on SQL Basics. In this post, we will discuss the importance of data and information when running SQL code.
When we work with SQL code, we often come across a series of SQL statements that have been created by someone else. However, as SQL administrators, it is our responsibility to customize the code for our system or test it and provide suggestions for improvement.
Having a basic understanding of SQL coding skills is crucial for SQL administrators. In this section, we will focus on the most common types of queries that you are likely to encounter in your SQL Server journey.
If you are looking to become proficient in all types of queries, we recommend diving deeper into the Joes 2 Pros SQL Queries series. This comprehensive series covers everything from beginner-level queries to advanced techniques.
Let’s take a look at an example from the video where we put square brackets around a table name. In SQL Server, the code generated automatically always includes these delimiters for every object in the database. However, there are certain scenarios where we must use square bracket delimiters. These include when table names are separated by a space, when they have the same name as a SQL Server keyword (which is generally not recommended), or when they are named in a way that is not easily interpreted by SQL Server.
If you prefer a visual explanation, we have a short video that covers the same topic in simple terms. You can find the video at the end of this post.
Action Item
Get a copy of our book, “SQL Basics: Running SQL Code,” for yourself and your friends. This book is a must-have reference for anyone working with SQL. It provides a comprehensive guide to running SQL code effectively.
Read the related blog post: SQL Basics: Running SQL Code – Day 2 of 10
We value your feedback! If you have any comments or suggestions regarding this blog post or the accompanying video, please leave a comment below.