create procedure sp_synchImagePhoto
(
	@file varchar(150) ,
	@type varchar(20) ,
	@width int ,
	@height int
)
as
set nocount on
begin
	if ( @type = 'full' )
	begin

		update _photo set full_width = @width , full_height = @height where full_image = @file
	
	end else if ( @type = 'thumb' ) begin

		update _photo set thumb_width = @width , thumb_height = @height where thumb_image = @file

	end else if ( @type = 'feat' ) begin
	
		update _photo set feat_width = @width , feat_height = @height where feat_image = @file
	
	end
end


GO