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?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Javeed M ShaikhPosted Oct 31, 2011, 8:07 PM
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.