1
2
3
4
5
6
7
|
| insert into SMS_MT(GUID,[LONG_SERV_NO],[SERV_CODE],NEED_DOWN_TIME, MOBILE_NO,MOBILE_NO_TYPE,FEE_TYPE,FEE,SMS_CONTENT,INTO_TIME,REPORT,MSGSUM,MSGSUB)
| values(NEWID(),'1069022600055','467111',GETDATE(),'18617322409',1,'01',0,'ÄúµÄÑéÖ¤Â룺232323,»Ø¸´TDÍ˶©.¡¾¶ÌÐÅ¡¿¡¾ÀÊÖ¡¿',GETDATE(),0,1,1)
|
| insert into SMS_MT_CM_WAIT(GUID,DOWN_TIME,LONG_SERV_NO,SERV_CODE,MOBILE_NO,MOBILE_NO_TYPE,FEE_TYPE,FEE,SMS_CONTENT,MSGSUM,MSGSUB)
| select GUID,NEED_DOWN_TIME,LONG_SERV_NO,SERV_CODE,MOBILE_NO,MOBILE_NO_TYPE,FEE_TYPE,FEE,SMS_CONTENT,MSGSUM,MSGSUB from SMS_MT where MSGID is null
|
|
|
