-compress-and-decompress-
https://www.mssqltips.com/sqlservertip/4559/sql-server-2016-compress-and-decompress-functions/
UPDATE
[WEBLABFILE].[dbo].[MyFileTables]
SET [file_stream]=COMPRESS([file_stream])
Where
[name]='BULTEN.docx'
UPDATE
[WEBLABFILE].[dbo].[MyFileTables]
SET [file_stream]=COMPRESS([file_stream])
Where
[name]='BULTEN.docx'
Hiç yorum yok