Updating a table - SQL Server Forums

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

SQL Server 2000 Forums

Transact-SQL (2000)

Updating a table

Author

Topic

mdhingra01
Posting Yak Master

179 Posts

Posted - 2005-04-12 : 11:12:54

I am running an update statemnt against TableA

Update TableA
Set Column1='AAA'
where column1='BBB'

The command executes, but withing 5 seconds reverts back to the old value
(BBB). I tried copying the table and renaming it and updating that one, same
thing happens, does someonw know why or how this is happening?

Thanks

mdhingra01
Posting Yak Master

179 Posts

Posted - 2005-04-12 : 11:50:04

Thanks guys,

since this was a small table I just snimply copied the table and dropped the column created a new column and re-populated it. The values seem to be sticking. The table may have been corrupt (I don't know how/why?)

Thanks for your help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources