Månedsarkiv: april 2015
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 blob fields, extract files, files., sql server
Kommentarer lukket til How to extract files from SQL Server blob fields into files.