Skip to content

Instantly share code, notes, and snippets.

@d8958101

d8958101/校正福彩、排列三期號的SQL語法.sql

Created February 23, 2018 02:21
Show Gist options
  • Save d8958101/cb4cfd172ddfc2ea67d3614bcc059878 to your computer and use it in GitHub Desktop.
Save d8958101/cb4cfd172ddfc2ea67d3614bcc059878 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
校正福彩、排列三期號的SQL語法.sql
Update Ssc.GL_SSC_Source_Status Set
LastDrawNo = '2018046',LastDrawDatetime = '2018-02-22 21:15:00.000',LastDrawLocalDatetime = '2018-02-22 21:15:00.000',
DrawNo = '2018047',DrawDatetime = '2018-02-23 21:15:00.000',DrawLocalDatetime = '2018-02-23 21:15:00.000',
NextDrawNo = '2018048',NextDrawDatetime = '2018-02-24 21:15:00.000',NextDrawLocalDatetime = '2018-02-24 21:15:00.000'
where SourceCode = 23
Update Ssc.GL_SSC_Source_Status Set
LastDrawNo = '18046',LastDrawDatetime = '2018-02-22 20:30:00.000',LastDrawLocalDatetime = '2018-02-22 20:30:00.000',
DrawNo = '18047',DrawDatetime = '2018-02-23 20:30:00.000',DrawLocalDatetime = '2018-02-23 20:30:00.000',
NextDrawNo = '18048',NextDrawDatetime = '2018-02-24 20:30:00.000',NextDrawLocalDatetime = '2018-02-24 20:30:00.000'
where SourceCode = 36
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment