Adds a picture to a specified person record.

Stored Procedure-Specific Information

Executing this procedure requires setting the values for Id and FileLocation. If FileLocation is not provided, both Content, which is an input stream of the file, and FileName with the extension should be provided.

To execute this procedure, enter:

    EXEC AddPersonPicture Id = '1', FileLocation = 'C:\\Users\\Downloads\\download.jpg'

Input

Name	Type	Description
Id	Integer	ID of a person.
CropX	Integer	X coordinate to where start cropping form in pixels.
CropY	Integer	Y coordinate to where start cropping form in pixels.
CropWidth	Integer	Width of cropping area in pixels.
CropHeight	Integer	Height of cropping area in pixels.
FileLocation	String	File to upload.
FileName	String	File name that is uploaded.

Result Set Columns

Name	Type	Description
Status	String	Execution status of the stored procedure.