SQLServerCentral.com Content tagged T-SQL, update

Update with CASE statement

Tue, 19 Feb 2013 07:00:00 UT

Stairway to T-SQL DML Level 10: Changing Data with the UPDATE Statement

Wed, 10 Oct 2012 06:00:00 UT

Unless you are working on a reporting-only application you will probably need to update tables in your SQL Server database. To update rows in a table you use the UPDATE statement. In this level we will be discussing how to find and update records in your database, and discuss the pitfalls you might run into when using the UPDATE statement.

Restricting updates?

Fri, 22 Jun 2012 06:00:00 UT

Using REPLACE in an UPDATE statement

Mon, 03 May 2010 06:00:00 UT

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

Swap column values

Mon, 25 May 2009 06:00:00 UT

Interchange column values using a single update query