1.請問,如何把一個txt檔塞進資料庫的Long Varchar型態的欄位(MS Sql)??
可以用sql 指令來完成這件事嗎?
2.這個Long Varchar可以再被Sql 指令Update成另一個txt檔嗎?

麻煩指導!

應該用blob型態會比較好吧?ms sql可指定為image 型態
存入欄位
以下程式碼為節錄請參考

procedure TxDB.FSTofield(fileName, fieldName, sSQL: widestring);
var qy: TADOQuery;
FS: TfileStream;
BS: TStream;
i: integer;
begin
fs := TFileStream.Create(fileName, fmOpenRead or fmShareDenyWrite);
fs.Seek(soFromBeginning, 0);
if fs.size > 0 then
begin
qy := TADOquery.create(application);
xsql.setData(qy, sSQL);
fs.Seek(0, 0);
if qy.RecordCount = 0 then
qy.Append else
qy.Edit;
BS := TBlobStream(qy.CREATEBLOBSTREAM(qy.FIELDBYNAME(FieldName), bmWrite));
BS.CopyFrom(fs, fs.Size);
i := bs.Size;
TblobField(qy.FieldByName(FieldName)).LoadFromStream(fs);
qy.Post;
end;
FS.free;
BS := nil;
qy.Free;
end;

取出
function TxDB.fieldToFS(var qy: TADOQuery; FiledName, fileName: widestring): Tstream;
var BS: TStream;
fs: TfileStream;
i: integer;
begin
try
fs := TFileStream.Create(fileName, fmCreate);
BS := TBlobStream(qy.CREATEBLOBSTREAM(qy.FieldByName(FiledName), bmRead));
fs.CopyFrom(bs, bs.Size);
i := fs.Size;
if i <= 0 then
raise exception.Create('檔案為零');
result := Fs;
finally
freeandnil(fs);
end;
end;