What is the problem about this

[mrzev]

I tried to execute this example : "update qwe qwe where login = 1"
same sql installed.

Successful rows 10 in my local if login = 0 successful rows 0 then now i tried to my virtual to execute it the code, successful rows 10 then login = 0 successful rows 10.

What is the problem even its login = 0, result success rows 10? in my local no problem.

sorry for my bad english.

[DretoNEX]

make sure you have the right query when you execute it sometimes the new query button on sql manager dose not include parent db's.

so try this

USE RohanGame
GO
UPDATE dbo.TCharacter SET mode = '100' WHERE id = 213123

or simply

UPDATE RohanGame.dbo.TCharacter SET mode = '100' WHERE id = 232323