Skip to content

Instantly share code, notes, and snippets.

@d8958101

d8958101/校正pk10, 快三期號的語法.sql

Created March 28, 2018 08:20
Show Gist options
  • Save d8958101/f1fd39b7856e1928546868dd61affdcb to your computer and use it in GitHub Desktop.
Save d8958101/f1fd39b7856e1928546868dd61affdcb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
校正pk10, 快三期號的語法.sql
--pk10校正期號的語法
update pkx.GL_pkx_Source_Status
set DrawLocalDateTime = DATEADD(day,-2,DrawLocalDateTime)
where SourceCode in ('00038')
--校正快三期號的語法
update KENODB.ks.GL_KS_Source_Status
set DrawLocalDateTime =DATEADD(day,-2,DrawLocalDateTime)
where SourceCode in ('00041','00043','00044','00045','00046')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment