USE master
GO
IF EXISTS(SELECT * FROM sysdatabases WHERE NAME = 'ImageDB')
DROP DATABASE ImageDB
GO
CREATE DATABASE ImageDB
ON
(
NAME = 'ImageDB_Data',
FILENAME = 'D:\ImageDB_Data.mdf'
)
LOG ON
(
NAME = 'ImageDB_Log',
FILENAME = 'D:\ImageDB_Log.ldf'
)
GO
USE ImageDB
GO
IF EXISTS(SELECT * FROM sysobjects WHERE NAME = 'ImageTable')
DROP TABLE ImageTable
GO
CREATE TABLE ImageTable
(
imgNo INT IDENTITY(1,1),
pictureName VARCHAR(20),
ImageContent IMAGE
)
GO
CREATE PROC sp_ImageTable
@name VARCHAR(20),
@image IMAGE
AS
INSERT INTO ImageTable VALUES(@name,@image)
GO
SELECT * FROM ImageTable
GO
DELETE FROM ImageTable
GO
二进制图片的读写
需积分: 9 194 浏览量
2008-08-01
19:09:41
上传
评论
收藏 38KB RAR 举报
二进制图片的读写.rar （17个子文件） 
二进制图片的读写 二进制图片的读写 ImageDemo 
Image.sql 672B ImageDemo.suo 8KB ImageDemo ImageDemo.suo 9KB ImageDemo bin Debug 
ImageDemo.exe 28KB ImageDemo.pdb 26KB DataBaseAccess.cs 2KB frmPicture.cs 7KB obj Debug ImageDemo.exe 28KB ImageDemo.projdata 10KB ImageDemo.pdb 26KB temp TempPE ImageDemo.frmPicture.resources 7KB ImageDemo.csproj.user 2KB ImageDemo.csproj 5KB App.ico 1KB frmPicture.resx 10KB AssemblyInfo.cs 2KB ImageDemo.sln 913B资源评论
