Tag Archive

Tag Archives for " UPDATE "

What is the Difference Between Merge and Update?

When modifying one table based on the contents of another it may be tempting to simply use the merge statement, but before you throw away all other forms of modifying data, I think it’s important for you to know the difference between merge and update. What is the Difference Between MERGE and UPDATE? Both the […]

Continue reading

Introduction to the UPDATE statement

The UPDATE statement is used to change data within columns of a SQL Server data table.  In this article we’ll explore how to use the UPDATE statement.  We discuss some best practices, limitations, and wrap-up with several examples. This is the third article in a series of articles.  You can start at the beginning by […]

Continue reading

Introduction to SQL Server Data Modification Statements

Metamorphisis

In this article we’ll discover data modification statements used to modify data in SQL server using the INSERT, UPDATE, DELETE, and MERGE statement. The SELECT, INSERT, UPDATE, DELETE, and MERGE statement are collectively referred to DML (Data Manipulation Language) statements.  These statements allow you to view and modify data.  We extensively cover SELECT in other […]

Continue reading