This is a simple and powerful API to send your SMS directly from your Microsoft
SQL Server. This API can be used to send all kinds of message types, including ordinary
text, binary, MMS and Unicode messages. This is a service that can be installed
directly on the MSSQL server, or on an application server.
Benefits
- SMS In/Out directly in the SQL server, without programming.
- Simple and easy to implement
- Powerful
- Wide support for message types and features
- Extended delivery reports with MCC/MNC and revenue/cost
information.
- SMS applications can be made using T-SQL statements only.
Requirements
- Microsoft SQL Server 2000 or higher (older versions are not tested)
- Server/computer on which to install your script/application. Can be installed
directly on the MSSQL server or on a separate server.
Example
| -- Send
SMS |
|
INSERT
INTO
SMS_Out (Tel, Msg) VALUES
(12345678, 'test')
|
| |
|
-- Response to incoming SMS
|
CREATE TRIGGER
SMS_In_Trigger
ON SMS_In
FOR
INSERT
AS
|
|
INSERT
INTO
SMS_Out (Tel, Msg) |
| SELECT
Tel, 'Thank you for subscribing to our service.'
|
|
FROM inserted
|
See more examples
here. Please
look at the documentation for the exact syntax.
Code example
Please visit our MSSQL code example page.
Documentation
You will find the MSSQL API documentation
here.
How to start
Sign up with our free online registration.
You will get 5 credits for your trial. You can then buy more credits with your credit
card. You may also contact sales@vianett.com.
API functions
| SMS delivery (Bulk SMS) |  |
| SMS Two-way SMS | |
| SMS billing | |
| SMS final delivery reports | |
| SMS intermediate delivery reports | |
| Status reports | |
| Extended status reports | |
| MMS delivery/billing | |
| CC Payment | |
| Replypath | |
| Campaign | |
| Multiple connections | |
| Choose route per SMS | |
| High throughput | (50/SEC) |
| Low latency | |
| Required experience for implementation | MSSQL |
| Alpha numeric sender id | |
| Binary support | |
| Concatenated, split by client | |
| Concatenated, split on server | |
| HLR | |
| API method | YAP |
| Unicode support | |
| Scheduled on server | |
| Flash SMS | |
| OTA | |
| Location services | |
| VPN channel encryption | |
| Statistics overview | |
| Statistics details | |
| Message tracking | |
| Message queue status | |
| Message export | |
| Sub accounts | |
Show more functions.