how to improve performance of update query in sql?

Posted by angel ansari on Stack Overflow See other posts from Stack Overflow or by angel ansari
Published on 2010-05-17T13:12:25Z Indexed on 2010/05/17 13:20 UTC
Read the original article Hit count: 142

Filed under:

I want to improve the performance of this update query because when it take lots of time to execute:

Qry = "update tab1 set cDate=GetDate() where right('000000000000'+in_num,12)='" & InvNo.PadLeft(12, "0") & "' and (Total-Amount)<>Balance <>Balance and cDate is null"

© Stack Overflow or respective owner

Related posts about sql