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

MSSQL example code

What is MSSQL?

MSSQL example

How to start / more information