title: sql update next day no row effect
body: <p>I want update tomorrow if today overtime work. But I have some problem no row effect.
  lembur_time = overtime work type data int</p>
  
  <pre><code>update kkpsurabaya 
  set clock_in='' 
  where lembur_time &gt;=240 
      and name='yuyun dwi astutik' 
      and date = DATEADD(day, 1, '2016-05-26') 
  </code></pre>
  
  <p>(0 row(s) affected) if use syntax like that but if </p>
  
  <pre><code>update kkpsurabaya 
  set clock_in='' 
  where name = 'yuyun dwi astutik' 
      and date = DATEADD(day, 1, '2016-05-26')
  </code></pre>
  
  <p>without lembur_time >= 240 this work</p>
  
  <p>I tried</p>
  
  <pre><code>select Name, lembur_time 
  from kkpsurabaya 
  WHERE lembur_time &gt;=240
  </code></pre>
  
  <p>and I have data with name yuyun dwi astutik lembur_time = 245</p>
  
  <p><a href="http://i.stack.imgur.com/jlrY2.png" rel="nofollow">image1</a>
  <a href="http://i.stack.imgur.com/hW1Ka.png" rel="nofollow">image 2</a></p>