How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
What is SQL? What is the difference between SQL the language and SQL the server.
How to use the output clause with Data Manipulation Language (DML) statements like INSERT, UPDATE, and DELETE.
What is the difference between the DELETE, TRUNCATE, and DROP statements in T-SQL?
How to use IDENTITY columns in a table. An IDENTITY field is very similar to an auto-number field, where the number will automatically be added as each record is inserted.
How to use an INSERT statement to add records to a table in SQL Server. We will begin with just a simple INSERT statement that will add one row into the table.
What is the data manipulation language (DML)? How to write the INSERT, UPDATE, and DELETE statements in T-SQL.