Inserting a file into nvarbinary column in SQL Server 2000

[Morrislgn]

Hi Folks,

I was wondering if someone could give some advice on the best way to insert a file to nvarbinary column.

Currently, I have a table like so:

FileID (bigInt, 8)
Name (nvarchar, 255)
File (nvarbinary, 8000)

I would like to insert a file into the file column.

The problem is reading the file from the filesystem into the database.Could anyone give me some advice on the best way to do this?

Many thanks in advance,

Morris

[rmiao]

Take look at textcopy in sql2k samples.