Query in SqlServer

Question

Hi friends i want to know that how to create a query to insert a document like our CV or Resume when we retrieve it?

Javeed M Shaikh · Answer

Hi Michell the only thing i can think of right now if it needs to be done by direct SQL is as follows: INSERT INTO myTable(columnname) SELECT * FROM OPENROWSET(BULK N'C:\myresume.doc' SINGLE_BLOB) ; I am assuming that myTable is having a column named columnname of type varbinary(max). This will not work in SQL 2000 so try in higher version.