BFILE on MS SQL Server

[DenizD]

ello!

Maybe you know the Type BFILE from Oracle Databases.
BFILE (External Binary File) is a binary file stored outside of the database in the host operating system file system, but accessible from database tables.

What is the BFILE equivalent on a Microsoft SQL Server? I could not find one in the MSDN or Documentation - so maybe there is none?

 

[mrdenny]

There is no datatype where the file resides out side of the SQL Server and can be accessed via the database. However you can store binary files up to 2GB in size in a column with the datatype IMAGE (is SQL 2000 and below) or VARBINARY(MAX) (if SQL 2005).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[DenizD]

Thank you.
For those with the same question, there is some Information
in "Module 2: Microsoft SQL Server Essentials"

http://www.microsoft-oracle.com/Siebel/Pages/Workshops.aspx