Home |  Page Index / Recent Changes / Access deniedRecently Commented | Search:
Login:     Password:   

  Bookmarks:   Page Index | Recent Changes | Access deniedRecently Commented | Access deniedUsers | Registration  
Print version :: Microsoft Word ready version

Sw4me: SMSReceptionCenter/MSSQL ...

This is an old revision of SMSReceptionCenter/MSSQL from 2006-04-04 05:01:21..

SmsRc and MSSQL

Microsoft SQL Server supports a very powerful SQL dialect. A lot of our customers prefer to use SmsRc just as a gateway between the phone and the server, implementing all SMS-handling logic in the server's stored procedures.


For this type of project, the file with just one ExecuteSQL action must be created. The SQL statement must call the stored procedure that is ready to handle incoming messages. Using appropriate ODBC escape sequence, the statement will look like this one:

{ CALL sp_incoming_sms ( [%Timestamp%],  [%Sender%] , [%Message%] ) }


 
There are no files on this page. [Display files/form]
There is no comment on this page. [Display comments/form]