Click here to Skip to main content
16,001,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a file whose path is available in a column of a table X
I need to write a trigger to save the file content into another column of the same table X while updating the table X.

Can any one plz advise

urgent!!!
Posted

1 solution

write in your update
SQL
trigger query
------------------------
INSERT INTO datafile(data)
SELECT * FROM OPENROWSET(
BULK 'C:\datafile.txt',
SINGLE_BLOB) AS x;</pre>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900