Menghilangkan item "REJECTION"

SELECT *

  FROM [QIS].[dbo].[T_Dfct]

  where Body_no = '1'

  and reject_flag ='xxxxx'

  and idfct is not null


update [QIS].[dbo].[T_Dfct]

 set Reject_Flg='0'

           (inflag='1'
           (inline='1'
           (inpos='6'
           (inptname='1FA'
           (in insp='Suhu'
           (inshift ='White'
           (out flar ='0'

where Tdfct_id in ('xxxxxx','xxxxx')
shere tdfct ='xxxx'


0 komentar:

Posting Komentar