begin update tblGallery set Caption = @Caption, ImageName =@Caption+'_'+ @GalleryID +'.jpg' where GalleryID = @GalleryID end and also like that begin select @@Identity; update tblGallery set Caption = @Caption, ImageName =@Caption+'_'+ @@Identity +'.jpg' where GalleryID = @GalleryID end
--Part of the SQL Procedure code begin update tblGallery set Caption = @Caption, ImageName =@Caption+'_'+ @GalleryID +'.jpg' where GalleryID = @GalleryID end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)