Microsoft SQL Server Tutorials
In this deep-dive tutorial, I will walk you through everything you need to know about the TRUNCATE TABLE statement in SQL Server. We will cover how it works under the hood, how it differs from DELETE, and the specific permissions and limitations you need to be aware of to manage your data infrastructure effectively. Truncate … Read more
This tutorial guides you through the complete process of adding a primary key to an existing table using T-SQL and SQL Server Management Studio (SSMS), tailored for a professional development environment. SQL Server Add Primary Key To Existing Table Whether you inherited a “heap” (a table without a clustered index) or simply forgot to define … Read more
In this article, I am going to walk you through exactly how to combine two (or more) columns in SQL. I will cover the modern functions, the legacy operators, and the dreaded “NULL trap” that ruins so many reports. How to Combine Two Columns in SQL Why Is Combining Columns So Complicated? Before we look … Read more
In this article, I am going to walk you through exactly how to write a SQL query to get column names from a table in SQL Server. I will cover the standard ANSI methods, the SQL Server-specific system views, and the quick shortcuts I use daily. SQL Query to Get Column Names from Table in … Read more
In this article, I am going to walk you through the exact methods I use to copy tables in SQL Server, from the quick-and-dirty one-liners to the robust enterprise-grade scripts. SQL Server Copy Table To Another Table Method 1: The “Select Into” When I need to make a quick backup of a table before running … Read more
In this article, I am going to walk you through exactly how to alter a table to add a column at a specific position in SQL Server, why this happens, how to achieve your goal using the tools available, and the architectural implications of forcing specific column positions in a relational database. Alter table add … Read more
UDTTs are one of the most underutilized yet powerful features in the T-SQL. They allow you to pass entire tables of data into stored procedures and functions as a single parameter. In this comprehensive guide, I will take you through the architecture, benefits, and best practices of User Defined Table Types. We will move beyond … Read more
In this guide, I am going to walk you through everything you need to know to create a table with an identity column in SQL Server. I will share the syntax and the best practices I use today to ensure data integrity. SQL Server Create Table With Identity Column What is an Identity Column in … Read more
Recently, I tried force a value into the identity column, SQL Server stoped me with the error Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF. Cannot insert explicit value for identity column in table I was executing the following query. SQL After executing the query above, I got … Read more
In this tutorial, I am going to walk you through exactly how to handle these changes with the precision of a seasoned DBA. Whether you are looking to modify a column’s data type using ALTER TABLE or move a table to a completely different security schema using ALTER SCHEMA, I will cover every angle. SQL … Read more