＋设为首页 ＋添加到收藏夹
如何在sqlserver中的image类型中插入数据?
CREATE PROCEDURE sp_textcopy (
@srvname varchar (30),
@login varchar (30),
@password varchar (30),
@dbname varchar (30),
@tbname varchar (30),
@colname varchar (30),
@filename varchar (30),
@whereclause varchar (40),
@direction char(1))
AS
DECLARE @exec_str varchar (255)
SELECT @exec_str =
textcopy /S + @srvname +
/U + @login +
/P + @password +
/D + @dbname +
/T + @tbname +
/C + @colname +
/W " + @whereclause +
" /F + @filename +
/ + @direction
EXEC master..xp_cmdshell @exec_str
下面是一个拷贝图像到SQL Server的pubs数据库的例子, 表名pub_info, 字段名logo，图像文件名picture.bmp，保存到pub_id=0736记录
sp_textcopy @srvname = ServerName,
@login = Login,
@password = Password,
@dbname = pubs,
@tbname = pub_info,
@colname = logo,
@filename = c:\picture.bmp,
@whereclause = " WHERE pub_id=0736 ",
@direction = I
