MSSQL example code

ViaNett provides you with code examples and programming objects, to help you connect to our gateway using the programming language of your choice. You are welcome to try these scripts. Sign up now to get 5 free SMS.

What is MSSQL?

Microsoft SQL Server (MSSQL) is a powerful relational model database server provided by Microsoft. One of its primary query languages is T-SQL. SQL Server is widely used. Microsoft also supplies a version free of charge. See the official home page for more information.

MSSQL example

This example code is based on the MSSQL API. To try this code, simply register for free and get 5 free SMS.

-- Send SMS
INSERT INTO SMS_Out(Tel, msg)
VALUES('4790000000', 'hello world')
 
-- Check Delivery Status
SELECT MsgID, FromNumber, Tel, msg, [Sent], SentDate, 
       DeliveryDate, DeliveryStatus, ok, ErrorCode, ErrorDescription
FROM SMS_Out_Log
 
-- Incoming messages
SELECT MsgID, Tel, Msg, DestTel, ReplyPathID
FROM SMS_In
 
-- 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

How to start / more information

Sign up now to get 5 free SMS. Go to the MSSQL API page for more information on how to use this API.