SQL Server

Multimodal Input: Image URL

See more AI Examples

Demonstrates sending a request that includes both text and an image URL for the AI to analyze. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @ai int
    EXEC @hr = sp_OACreate 'Chilkat.Ai', @ai OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- The provider can be "openai", "google", "claude", "deepseek", "xai", or "perplexity".
    -- Support for additional providers will be added in future versions of Chilkat.
    EXEC sp_OASetProperty @ai, 'Provider', 'google'

    -- Use your provider's API key.
    EXEC sp_OASetProperty @ai, 'ApiKey', 'MY_API_KEY'

    -- Choose a model.
    EXEC sp_OASetProperty @ai, 'Model', 'gemini-2.5-flash'

    -- Add both text input, and an image URL.
    -- If the AI provider does not natively support image URLs, Chilkat will download the image data to memory and send the image data to the AI provider (within the "Ask" method call).
    EXEC sp_OAMethod @ai, 'InputAddText', @success OUT, 'Describe what you see in the following image.'
    EXEC sp_OAMethod @ai, 'InputAddImageUrl', @success OUT, 'https://www.chilkatsoft.com/images/starfish.jpg', ''

    -- Ask the AI for text output.
    EXEC sp_OAMethod @ai, 'Ask', @success OUT, 'text'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ai, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @ai
        RETURN
      END

    -- Get the text response.
    DECLARE @sbResponse int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponse OUT

    EXEC sp_OAMethod @ai, 'GetOutputTextSb', @success OUT, @sbResponse
    EXEC sp_OAMethod @sbResponse, 'GetAsString', @sTmp0 OUT
    PRINT @sTmp0

    -- -------------------------------------------------------------
    -- The response is in markdown format.
    -- Also see Markdown to HTML Conversion Examples.
    -- -------------------------------------------------------------

    -- Sample output:

    -- The image displays a single, vibrant **starfish** set against a plain **white background**.
    -- 
    -- Here's a more detailed description:
    -- 
    -- *   **Object:** A single starfish.
    -- *   **Shape:** It has the characteristic five-pointed star shape, with each arm tapering slightly to a rounded end. The arms appear somewhat plump and substantial.
    -- *   **Color:** The starfish is a beautiful **warm, golden-orange color**, with subtle variations in hue that suggest natural texture and depth. Some areas might lean a little more yellow, while others have a slightly richer, deeper orange tone.
    -- *   **Texture:** Its entire surface is visibly **textured**, covered in numerous small, raised bumps or granular patterns. These details are consistent across all the arms and the central body, giving it a rough, almost sandpaper-like appearance, typical of a real starfish.
    -- *   **Lighting & Depth:** The lighting on the starfish highlights these textures, creating subtle shadows in the crevices between the bumps and making the object appear distinctly three-dimensional and lifelike. The light seems to come from above, casting gentle shadows that define its form.
    -- *   **Background:** The starfish is isolated against a pure white, featureless background, which makes it stand out prominently as the sole subject of the image.
    -- 
    -- Overall, it's a clear, well-lit photograph of a textured, orange starfish.

    EXEC @hr = sp_OADestroy @ai
    EXEC @hr = sp_OADestroy @sbResponse


END
GO