Tag-arkiv: blob fields

How to extract files from SQL Server blob fields into files.

— Write all database files (pdf) to file. ——— ——— ——— ——— ——— ——— ——— DECLARE CURSOR_Id CURSOR FOR (SELECT [RecId] FROM [dbo].[SYSOUTGOINGEMAILDATA]) DECLARE @RecId BIGINT; OPEN CURSOR_Id FETCH NEXT FROM CURSOR_Id INTO @RecId WHILE (@@FETCH_STATUS -1) BEGIN DECLARE @Data … Læs resten

Udgivet i SQL Server - scripts | Tagget , , , | Kommentarer lukket til How to extract files from SQL Server blob fields into files.