Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, update Rss

   Items 1 to 6 of 6   
 

A Hazard of Using the SQL Update Statement

If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.  Read more...
By Dwain Camps 2013/09/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,081 reads

Update with CASE statement

By Raghavendra Mudugal 2013/02/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,452 reads

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

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.   Read more...
By Gregory Larsen 2012/10/10 | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,862 reads

Restricting updates?

By John Shahan 2012/06/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,770 reads

Using REPLACE in an UPDATE statement

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.  Read more...
By Additional Articles 2010/05/03 | Source: SQLTeam.com | Category: t-sql
Rating:  Rate this |   Briefcase | 7,055 reads

Swap column values

Interchange column values using a single update query  Read more...
By Divya Agrawal 2009/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,014 reads
   Items 1 to 6 of 6   
 
Tags
replace (1)    
stairway series (1)    
swap data (1)    
update with case (1)