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
sql
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