My simple sql update query is not working right :(

Answer 1

In the video, your select goes like

and not IsAnnouncement = 1

wich gives entirely different results as in your update

and not (IsAnnouncement = 1)

It seems you are suffering from an operator precedence issue .

Edit

as the queries don't match in your video and although you say they have matched could you copy paste following script and let us know if or if they do not give you the same results? (I for one would have a hard time believing that the rows affected would differ)

begin tran

select * 
from tblBoardPost      
where 
  IdBoardPost = 1278    
  and IdAddress = 212787    
  and Subject = N'ttreterte'    
  and Banner is null    
  and UniqueSubject = N'ttreterte5'    
  AND (NOT ([IsAnnouncement] = 1))     
  AND (NOT ([IsSticky] = 1))     
  AND (NOT ([IsLocked] = 1))     
  and IsVisible = 1    
  and IdUserModified = 1    
  AND [IdNewsArticle] IS NULL    
  AND [IdList] IS NULL

update tblBoardPost    
  set IsSticky = 1
where 
  IdBoardPost = 1278    
  and IdAddress = 212787    
  and Subject = N'ttreterte'    
  and Banner is null    
  and UniqueSubject = N'ttreterte5'    
  AND (NOT ([IsAnnouncement] = 1))     
  AND (NOT ([IsSticky] = 1))     
  AND (NOT ([IsLocked] = 1))     
  and IsVisible = 1    
  and IdUserModified = 1    
  AND [IdNewsArticle] IS NULL    
  AND [IdList] IS NULL

rollback tran

Answer 2

I checked your video, and you should try the same SQL conditions, that you used to return one row in your select query, in your update query. The conditions in the two SQL statements in your video aren't the same, and I don't really care why; they're not apples to apples.

Just copy and paste the working WHERE clause over the non-working one.