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.
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
How to use the WHERE statement to filter records when a value IS NULL or IS NOT NULL 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.
How to use the WHERE statement to filter records when the value is either a Date or a Time in a T-SQL statement.
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.