How to send message using database

There is no in-build method to sending SMS but you can use external xmlhttp api in store procedure. See following thread for more detail https://www.niceonecode.com/Q-A/SQL/Query/Send-SMS--Email-Using-Backend-/20396

Feel free to ask if any issue.

Use following, where @sUrl is SMS send api url with parameters:

Create PROCEDURE SP_CallWebService @sUrl NVARCHAR(MAX)
AS 
BEGIN  
  DECLARE @iReq INT,
    @hr INT 
  DECLARE @errorSource VARCHAR(8000)
  DECLARE @errorDescription VARCHAR(8000) 
  DECLARE @sResponse NVARCHAR(MAX)
  EXEC @hr = sp_OACreate 'Microsoft.XMLHTTP',@iReq OUT

  EXEC @hr = sp_OAMethod @iReq,'Open',NULL,'GET',@sUrl,'false'
  if @hr<>0 
        print ' Failed in sp_OAMethod open'
  EXEC @hr = sp_OAMethod @iReq,'send'
  if @hr<>0 
        print ' Failed in sp_OAMethod send'
  BEGIN
    set @hr=0
    EXEC @hr = sp_OAGetProperty @iReq,'responseText',@sResponse OUT
    if @hr<>0 
        print ' Failed in sp_OAGetProperty'
  END
  
  EXEC sp_OADestroy @iReq
  EXEC sp_OADestroy @hr
END 
GO