Use this:

DECLARE @alert_text NVARCHAR(MAX) = 'Hello World';
EXEC dbo.sp_api_modal_alert @alert_text = @alert_text;

To get this: