怎样对mssql里面的image对象进行读写操作呢
可以实现对imgae字段所向插入一个值,也可以把这个值读取出来,
伏望大家指点,小弟期待...
可以实现对imgae字段所向插入一个值,也可以把这个值读取出来,
伏望大家指点,小弟期待...
解决方案 »
- Win2003+SQLServer2005服务器群集的配置问题
- 求助:SQL Server 2000 中的字符串拼接
- 新手提问 wince编程 数据库操作出现问题
- oracle中的自动增长函数,sql server 2005对应的方法是什么
- newid()与newid()比较
- 请教SQL SERVER的自动编码为什么会出现跳号现象,急
- 如何查出a表和b表之中不同的数据?
- 过年了,来个100分,问个问题哈,不知道还有人在不?200万条数据的表,分页查询速度慢
- 怎么用EXEC master..xp_cmdshell BCP 输出临时表内容到文件?
- 求一分年季月分组存储过程(语句)???
- 求一句sql
- Reporting Serices 报表订阅 方式为Windows文件共享是报错,请大虾帮帮忙
insert into @t select 'aaaa'
select * from @t
/*
img
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0x61616161(1 行受影响)
*/
UPDATETEXT
WRITETEXT
zjcxc (邹建) 的博客,看看老大的博客你会大涨见识
@srvname varchar (30),
@login varchar (30),
@password varchar (30),
@dbname varchar (30),
@tbname varchar (30),
@photoname varchar (30),
@filename varchar (30),
@whereclause varchar (40),
@direction char(1))
AS
--http://topic.csdn.net/u/20080421/09/f0f1a4d3-ea79-43e4-a8e7-f55025543ee4.html?1600242342
DECLARE @exec_str varchar (255)
SELECT @exec_str =
'textcopy /S ' + @srvname +
' /U ' + @login +
' /P ' + @password +
' /D ' + @dbname +
' /T ' + @tbname +
' /C ' + @photoname +
' /W " ' + @whereclause +
'" /F ' + @filename +
' / ' + @direction
EXEC master..xp_cmdshell @exec_str ,no_output create table photo(id int identity(1,1),photo image,memo nvarchar(50) default 'my photo ')
go insert photo(photo) values(0x)
insert photo(photo) values(0x)
--select * from photo
--truncate table photo --读入
sp_textcopy 'ibm', 'sa ', '123', 'liz', 'photo', 'photo', 'd:\ip.jpg', 'where id=1', 'I' --输出
sp_textcopy 'ibm', 'sa ', '123', 'liz', 'photo', 'photo', 'e:\ip.jpg', 'where id=1', 'o'