金仓短信中间件,发短信的SQL语句举例如下
(以Oracle数据库为例,关于ID字段,Oracle可使用序列,SQL Server使用自增字段):
#Oracle
INSERT INTO SYSTEM.SMS_BOXSENDING
("ID","SENDER","RECEIVER","CONTENT",
"SENDTIME","INSERTTIME","RETRYTIMES","INPOOL","MODULEID","SENDMODE")
VALUES(1,'admin','13301097150','测试发送短信',
'2008-08-08 20:00:00','2008-08-08 20:00:00','2','0','COM1','2') |