22,210
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
CoolAbu 2003-02-22
- 打赏
- 举报
ADO的recordset有一个AppendChunk 方法，你试试
happydreamer 2003-02-22
- 打赏
- 举报
在DOS模式下用textcopy 工具
textcopy /S yourservername /U sa /D Northwind /T abc /C pic /W "where a = 2 " /F C:\picture1.jpg /I /Z
textcopy /S yourservername /U sa /D Northwind /T abc /C pic /W "where a = 2 " /F C:\picture1.jpg /I /Z
pengdali 2003-02-22
- 打赏
- 举报
下面是一个拷贝图像到SQL Server的pubs数据库的例子, 表名pub_info, 字段名logo，图像文件名picture.bmp，保存到pub_id='0736'记录
sp_textcopy @srvn
ame = 'ServerName',
@login = 'Login',
@password = 'Password',
@dbname = 'pubs',
@tbname = 'pub_info',
@colname = 'logo',
@filename = 'c:\picture.bmp',
@whereclause = " WHERE pub_id='0736' ",
@direction = 'I'
sp_textcopy @srvn
ame = 'ServerName',
@login = 'Login',
@password = 'Password',
@dbname = 'pubs',
@tbname = 'pub_info',
@colname = 'logo',
@filename = 'c:\picture.bmp',
@whereclause = " WHERE pub_id='0736' ",
@direction = 'I'
alost 2003-02-22
- 打赏
- 举报
up
