need help: I can not update record

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

SQL Server Development (2000)

need help: I can not update record

Author

Topic

mccrash
Starting Member

3 Posts

Posted - 2007-01-15 : 04:18:10

hello

I have problem to change 4 th record in my table using enterprise manager other records can be updated and successfully added. I faced this problem after adding a "image" row and redefining my primary key in this table..

I need help! I would be glad you can show me how can I solve this problem (Sql server 2000)

Thank you.

nr
SQLTeam MVY

12543 Posts

Posted - 2007-01-15 : 04:29:27

Use an update query in query analyser instead of enterprise manager?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

mccrash
Starting Member

3 Posts

Posted - 2007-01-15 : 09:18:50

hello nr,

I used query analyzer too, It says succesfully executed but nothing will be changed in database.

any suggestion?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-15 : 09:21:47

can you post the update query here ?

mccrash
Starting Member

3 Posts

Posted - 2007-01-15 : 11:01:43

update query here :

UPDATE Categories
SET CategoryName = 'sag'
WHERE (CategoryName = 'Saglik')

its simple.. any suggestion?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-15 : 18:30:47

Any error message when you run the update query ?

any rows return with the select ?

select * from Categories where CategoryName = 'Saglik'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources