Monthly Archives: October 2018

Overview of the SQL Insert statement

This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The previous articles are focused on SQL query techniques, all centered around the task of data preparation and data transformation. The … Continue reading

Posted in SQL | Tagged , , | Leave a comment

SQL Pivot and Unpivot relational operatots

In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose SQL Server data. Also, we’ll discuss both static and dynamic ways to use PIVOT and UNPIVOT relational operators that can … Continue reading

Posted in SQL | Tagged , , | Leave a comment

Overview of the SQL Update statement

In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table.    After reading this article, you’ll understand the following topics covering how to use a simple SQL update statement on multiple columns … Continue reading

Posted in SQL | Tagged , , , , | Leave a comment