#rowcount

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

with computed value

with the compound operator

with the defaults

with SQL joins

with the Where clause

on a remote table

with use Top(n) clause

with…

Recently a friend of mine asked me about deleting a duplicate record from a table without deleting both records. Having been in a situation I drafted up a sample script and emailed to him. DECLARE @tbl1 TABLE ( id int, color varchar(50) ) INSERT INTO @tbl1 (id, color) VALUES (1,'blue') ,(1,'blue') ,(1,'blue') ,(2,'red') ,(3,'green') ,(4,'yellow') ,(5,'orange'); First off let’s see all the rows in…