Restore and Recovery
The restoration process of a SQL Server database passes through two phases: Restore and Recovery.
Deardurff
SQL Statement Categories
There are four main categories of statements used when writing T-SQL. What are the differences between each of these categories?
SQL Four-Part Names
The four-part names of SQL Server objects. How to reference objects in SQL Server by their four-part name and how to use it in a T-SQL statement.
Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
Columns and Records
In this post, we discuss what columns and records are in a SQL table including an explanation of objects and entities.
Filtering Records by Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
Filtering Records by Character Data
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.
Filtering Records by Dates and Times
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
Filtering Records by NULL Values
How to use the WHERE statement to filter records when a value IS NULL or IS NOT NULL in a T-SQL statement.
Sort Records using ORDER BY
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.