sql2005表及存储过程的创建（一久不写，记忆便会模糊，留待以后自己参考了）

 

use iSOSDB
if not exists (select *  from dbo.sysobjects where name='iSosImageInfos')
begin
    Create table iSosImageInfos
    (
 ImageID int identity(1,1) not null,
 ImageName varchar(20) null,
 ImageData image null,
 AddDate datetime null
    )
end
go

create procedure dlx_addLinkImage
@ImageName varchar(20),
@ImageData image
as
begin
    if exists( select ImageName from iSosImageInfos where ImageName=@ImageName)
 begin
 update iSosImageInfos
 set ImageData=@ImageData,AddDate=getdate()
 end
    else
 begin
 insert into iSosImageInfos(ImageName,ImageData,AddDate)
 values(@ImageName,@ImageData,getdate())
 end
end
go

create procedure dlx_getImage
@ImageName varchar(20)
as
begin
select ImageData from iSosImageInfos where ImageName=@ImageName
end

--select ImageData from iSosImageInfos where ImageName='china'