Reading Time: 6 minutes The TRUNCATE TABLE statement is a simple statement that has a very singular purpose in Microsoft SQL Server. In this very brief tutorial, we’ll cover all the important information you need to know about the TRUNCATE TABLE statement. We’ll cover these topics: What is the SQL Server TRUNCATE TABLE statement? Continue Reading
SQL Server Logical Query Processing Order: Explained!
Reading Time: 3 minutes When executing a query, SQL Server will process the different clauses of that query in a very particular order. Other programming languages like C++ or C# will process code in a top-down manner. SQL Server does not work that way. Take a look at the following two tables, Products and Orders: Using Continue Reading
SQL Server Temp Tables: A How-To Guide for Beginners
Reading Time: 7 minutes SQL Server temp tables are very useful tools available to us when it comes to querying and developing SQL Server databases. Temp tables offer a very easy way to create a table for a singular purpose and then remove that table when we are finished with it. In this very brief Continue Reading
SQL Server Sequence Object: Explained for Beginners
Reading Time: 7 minutes One of the most useful tools available to us in Microsoft SQL Server is the sequence object. Sequence objects are a great way to let SQL Server track and update an integer value that can be used to populate a primary key column. In this very brief tutorial, we’ll discuss Continue Reading
Do you know this IMPORTANT RULE about Foreign Key Constraints?
Reading Time: 5 minutes Foreign Key Constraints in Microsoft SQL Server are excellent for preserving the integrity of our data. We use a foreign key constraint to basically establish a parent-child relationship between two tables. A foreign key constraint will enforce that a value must first exist in the parent table before it can Continue Reading