如何将我们的所有图像从SQL Server 中的VARBINARY(MAX)字段转储到文件系统？

CREATE PROCEDURE ExportImagesToFileSystem
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @ImageId INT
    DECLARE @ImageData VARBINARY(MAX)
    DECLARE @ImagePath NVARCHAR(MAX)

    DECLARE ImageCursor CURSOR FOR
    SELECT ImageId, ImageData
    FROM Images

    OPEN ImageCursor
    FETCH NEXT FROM ImageCursor INTO @ImageId, @ImageData

    WHILE @@FETCH_STATUS = 0
    BEGIN
        SET @ImagePath = N'C:\Images\' + CAST(@ImageId AS NVARCHAR(10)) + N'.jpg'

        DECLARE @FileStream VARBINARY(MAX)
        SET @FileStream = @ImageData

        EXEC sp_filestream_write_to_file @FileStream, @ImagePath, 0, 0

        FETCH NEXT FROM ImageCursor INTO @ImageId, @ImageData
    END

    CLOSE ImageCursor
    DEALLOCATE ImageCursor
END