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	Accepts Input Streams	Description
Id	Integer	False	ID of a person.
CropX	Integer	False	X coordinate to where start cropping form in pixels.
CropY	Integer	False	Y coordinate to where start cropping form in pixels.
CropWidth	Integer	False	Width of cropping area in pixels.
CropHeight	Integer	False	Height of cropping area in pixels.
FileLocation	String	False	File to upload.
Content	String	True	The content as InputStream to be uploaded when FileLocation is not specified.
FileName	String	False	File name that is uploaded.

Result Set Columns

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