SQL Server provides the max specifier, which expands the storage capacity of the varchar, nvarchar, and varbinary data types. varchar(max), nvarchar(max), and varbinary(max) are collectively called ...

A CLR UDT has a limit of 8000 bytes - I doubt thats big enough to pack a file into. I guess you could use custom serialization and store the compressed file in a different table using the ...