Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    Load file into database

    29-12-2015 17:37:49 MSSQL / Operation 0 Bookmark(s) 195 View(s)

     

    
DECLARE @data VARCHAR(MAX);

SELECT @data = CAST(bulkcolumn AS VARCHAR(MAX)) 
FROM OPENROWSET(BULK'C:\temp\test.txt', SINGLE_BLOB) AS x;

UPDATE MyTable SET Text = @data;