CREATE PROCEDURE [dbo].[DeleteSMSReminder](
@SMSRID int
)
AS
BEGIN
DELETE FROM SMSReminders WHERE SMSRID = @SMSRID
END
CREATE PROCEDURE [dbo].[GetApprovedCells]
AS
BEGIN
SELECT ApprovedCellNo, CellNum, Name, SendSMS FROM ApprovedSMSCells ORDER BY Name
END
CREATE PROCEDURE [dbo].[GetModemForCell]
( @CellDigits varchar(50)
)
AS
BEGIN
SELECT ModemsettingNo FROM ModemAssociatedCellNumbers
WHERE AssociatedCellNum = @CellDigits
END
CREATE PROCEDURE [dbo].[GetSMSReminders]
AS
BEGIN
SELECT * FROM SMSReminders ORDER BY SMSDate, SMSTime
END
CREATE PROCEDURE [dbo].[InsertSMSReminder](
@SMSDate date, @SMSTime time(7)
)
AS
BEGIN
INSERT INTO [dbo].[SMSReminders]
([SMSDate]
,[SMSTime])
VALUES
(@SMSDate,@SMSTime)
END;