Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Bulk edit column

Author  Topic 

gavh
Starting Member

1 Post

Posted - 2009-07-21 : 18:02:21
Hi,
I have a table called default_en_listingsdb which has an expiry date in column 4 called listingsdb_expiration

I would like to bulk change all of the dates in this table to december 31st 2009. Can this be done? What should I do..

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-07-21 : 18:46:51
[code]UPDATE default_en_listingsdb
SET listingsdb_expiration = '2009-12-31'[/code]

Some days you're the dog, and some days you're the fire hydrant.
Go to Top of Page
   

- Advertisement -