怎样在SQL2000中储存图形图像

来源：互联网发布：hadoop oracle 知乎编辑：程序博客网时间：2024/06/10 03:55

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'

delphi:

procedure TForm1.Button1Click(Sender: TObject);
begin
if OpenPictureDialog1.Execute then
Image1.Picture.LoadFromFile(OpenPictureDialog1.FileName);
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
   ADOTable1.Append;
   TBlobField(ADOTable1.FieldByName('FImage')).LoadFromFile(OpenPictureDialog1.FileName);
   ADOTable1.Post;
end;

你先
create table 表(id int,myimage image)
go
insert 表 values(2,0x)
go
--调用上面的过程:
sp_textcopy '你的服务器名','sa','你的密码','test','dali','MyImage','c:/图片.bmp','where ID=2','I' --注意条件是 ID=2
--就OK了

有关的连接

http://search.csdn.net/Expert/topic/1673/1673711.xml?temp=.5985681

http://www.csdn.net/develop/Read_Article.asp?Id=17699