LOAD_FILE

Loads file contant in bytes.

Syntax

LOAD_FILE ( 'file_path' )

Arguments

'file_path'

Is an expression of the type varchar or nvarchar containing a path of a file.

Return types

binary

Example

SELECT JSON_PATH(
  DETECT_FACES(
    LOAD_FILE('http://local-content.local/img09.jpg'),
    'https://westus.api.cognitive.microsoft.com/face/v1.0/detect',
    'cf23df2207d99a74fbe169e3eba035e6'),
  '$[0].faceAttributes.age') as age

See Also