CODEWITHSUNDEEP
sql-server-2005sql-update
Anthony
Anthony

Reputation:

SQL Query fails to update

I am trying to update a row on an SQL SERVER 2005. When I run the SQL, I receive a message indicating that the Execution was successful and 1 row was affected. However, when I do a select against this row I supposedly updated, the value remains unchanged. What's going on with this SQL server when a successful query does absolutely nothing.

The query is:

UPDATE [database1].[dbo].[table1] 
   SET [order] = 215 
WHERE [email] = '[email protected]'

Upvotes: 0

Views: 135

Answers (2)

KM.
KM.

Reputation: 103589

check for a trigger on [database1].[dbo].[table1], possibly it is doing something you are not aware of.

EDIT

without seeing the trigger code, you probably just need to add support for [order] into the trigger, since it is a new column (based on your comment).

Upvotes: 1

Anthony
Anthony

Reputation:

Thanks KM I checked the triggers and you were right. There was a trigger that I had to disable to get the sql to work.

Upvotes: 0

Related Questions