CREATE PROCEDURE [dbo].[spUpdatePicture]
@id bigint,
@name varchar(255),
@desc text,
@category varchar(50),
@dateTime smalldatetime,
@uploader varchar(50),
@serverFilename varchar(50)
 AS
BEGIN
	UPDATE [tblPictures] SET [picture_filename] = @name, [picture_description] = @desc,  [category_name] =@category, [picture_upload_time] = @dateTime, [picture_uploader] = @uploader, [picture_serverfilename] = @serverFilename WHERE [picture_id] = @id
END


