Aubrey Love

Learn how to filter data using SQL WHERE IN for SQL SELECT, UPDATE, and DELETE queries with these several examples.

In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.

I often hear the words clause, statement, command, expression, batch, etc., used when describing aspects of SQL Server. Learn what these terms mean.

Learn how to use IS NOT NULL for a WHERE clause in SQL along with examples of how this can be used for SELECT, INSERT, UPDATE, and UPDATE.

Learn about the SQL Server .WRITE function along with how to use this to update data in VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.

Learn about the similarities and differences of STUFF, REPLACE, and WRITE when working with SQL Server text data.

In this article, we look at the basics of using SQL Server variables in T-SQL code to allow for more dynamic code creation.

In this article, we look at how to build a simple bar chart using SQL code along with a couple examples of how you can do this with your data.

In this article, we look at a comparison of the SQL Server DELETE and TRUNCATE commands and when and how to use these commands to delete data.

Learn various ways to use GROUP BY to summarize and rollup query results with examples along with using group by rollup, cube and grouping sets.

In this article learn how to update data in a SQL Server table from another table using a JOIN, the MERGE statement or a subquery.