Misc SQL Server UPDATE Examples

UPDATE - Single row

Update a single row of data.

BEGIN TRANSACTION
GO

UPDATE [dbo].[Students]
SET    employee_id_fk                = '3208'  ,
       gender_code                   = 'F'     ,
       marital_status_code           = 'M'  
WHERE  student_id = 11  
GO

COMMIT TRANSACTION
GO

UPDATE - Update multiple rows

Update multiple rows of data..

BEGIN TRANSACTION
GO

UPDATE [dbo].[ClassConvenings]
SET     acitve_flg                    = 2  
WHERE   class_convene_date > '2005-1-01 00:00:00.0' 
   AND  class_convene_date < '2005-12-31 00:00:00.0'
GO

COMMIT TRANSACTION
GO

If you find this site useful and are a book buyer/reader... You can support my site by clicking on one of the Links below to Abe books By doing this, I will receive a small commision on your purchase and making your purchase will not cost you any more money than if you went directly the site yourself! Abe Books sells books at a fraction of the original cost. I have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars including shipping costs Click on applicable icon to find books at Abe Books on ...
SQL Server 2008	SQL Server 2005	SQL Server 2000	T-SQL

Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. If it is printed they likely have a copy. I have also included a generic link to Abe Books below. Once on their site, you will find that they have a nice, easy to use search engine so to find what you are looking for.