-- ============================================= -- Author: -- Create date: -- Description: Returns the stored file bytes for a single reminder, for use by -- the Azure Blob Storage startup backfill after the row has been -- selected via fds__getReminderFiles_ForBlobArchive. -- ============================================= CREATE PROCEDURE [dbo].[fds__getReminderFileContent] @Id varchar(10) AS BEGIN SET NOCOUNT ON; SELECT TOP(1) [Id], [file] FROM [dbo].[fds__reminder] WHERE [Id] = @Id AND @Id is not null AND [file] IS NOT NULL; END