1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| ALTER proc [dbo].[uploadImage]
@ppr int ,
@imagename varchar ,
@imagecontent varchar,
@imagebinary image
as
begin tran
if exists (select ImageID from [ImageStorage] where ImageID = ( select codeimg from Agent where PPR=@ppr))
begin
--select ImageBinary from [ImageStorage] where ImageID = ( select codeimg from Agent where PPR=@ppr)
update ImageStorage set ImageName= @imagename, ImageContentType=@imagecontent , ImageBinary=@imagecontent where imageID = (select codeimg from Agent where PPR =@ppr)
end
else
insert into ImageStorage (ImageName , ImageContentType, ImageBinary) values (@imagename ,@imagecontent,@imagebinary)
commit |
Partager