d8958101

update KENODB.Config.Ks_Source
SET MondayStartTime = '09:37:00', TuesdayStartTime = '09:37:00', WednesdayStartTime = '09:37:00'
, ThursdayStartTime = '09:37:00', FridayStartTime = '09:37:00', SaturdayStartTime = '09:37:00', SundayStartTime = '09:37:00'

, MondayEndTime = '22:27:00', TuesdayEndTime = '22:27:00', WednesdayEndTime = '22:27:00'
, ThursdayEndTime = '22:27:00', FridayEndTime = '22:27:00', SaturdayEndTime = '22:27:00', SundayEndTime = '22:27:00'
where SourceCode in ('00045')

d8958101

--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')

d8958101

update GL_KENO_Source
SET InitDrawNo = 251453
where SourceCode = 4
update GL_KENO_Source_Status
SET DrawLocalDateTime = dateadd(day,-2,DrawLocalDateTime)
where sourcecode = 4

d8958101

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

d8958101

  {
    "BetradarEventCode": -1,
    "SportText": "Basketball",
    "CategoryText": "",
    "TournamentText": "*nba",
    "HomeTeam": "L.A. Clippers",
    "AwayTeam": "New York Knicks",
    "MatchStatus": "",
    "BetStatus": "",