CREATE proc insert_imagemaster   ----For Image Save By Sures Jaglan
@AlbumName varchar(100),              
@ImageUrl varchar(250),          
@EnteredBy bigint,
@UpdatedBy bigint    
as        
begin    
Declare @AMID bigint  
insert into AlbumMaster(AlbumName,EnterdBy,UpdatedBy)values(@AlbumName,@EnteredBy,@UpdatedBy)  
SET @AMID=(Select Ident_Current('AlbumMaster') )  
IF(@AMID is NOT NULL AND @AMID > 0)  
BEGIN  
insert into ImageMaster(AlbumMasterID,ImageUrl,EnteredBy,UpdatedBy)values
(@AMID,@ImageUrl,@EnteredBy,@UpdatedBy)                                                              
END  
end