Me: Can you do OCR to the text of this image?

ChatGPT:

The text from the image is:

• "REAL MILK great taste"
• "HORIZON ORGANIC"
• "ORGANIC WHOLE MILK"
• "VITAMIN D • UHT"
• "8 FL OZ (236 mL)"
• "USDA ORGANIC"

This is the text displayed on the milk carton. Let me know if you'd like to extract more information or need anything else!

How to create a SQL Server table to insert images from ChatGPT

Previously, we showed how to convert the text in images into text. Now, we need a table in SQL Server to store the data. I am assuming that you have SQL Server installed.

First, create the table:

Me: Generate the T-SQL code to create a table named comments with the columns id of type int with autonumeric columns (numbers generated automatically with the identity property) and the column description of type varchar(max)

ChatGPT:

Here is the T-SQL code to create the comments table with the specified columns:

CREATE TABLE comments (

    id INT IDENTITY(1,1) PRIMARY KEY,

    description VARCHAR(MAX)

);

• The id column is of type INT and is set to automatically generate numbers starting from 1, incrementing by 1, thanks to the IDENTITY(1,1) property.
• The description column is of type VARCHAR(MAX) to allow variable-length strings of any size.

Handle handwritten images in SQL Server with AI

Me: Can you do OCR to the text of this image and generate the T-SQL code to insert the text into the comments table previously created?

ChatGPT:

The text extracted from the image is:

• "We Start With Good"
• "Because all businesses should be doing something good."

Here is the T-SQL code to insert this text into the comments table:

INSERT INTO comments (description)

VALUES ('We Start With Good Because all businesses should be doing something good.');

This query inserts the text as a single row into the comments table, with the id column automatically generated.

Me: I am impressed. The OCR could read handwritten text easily.

Insert Data from a chart into a table

Me: I have the following chart.

Please insert the coordinates x and y in the following table based on the image attached:

CREATE TABLE Coordinates (

id INT IDENTITY(1,1) PRIMARY KEY,

x INT,

y INT

);

ChatGPT:

Based on the scatter plot, the coordinates (x, y) extracted are:

• (4, 2)

• (5, 3)

• (6, 4)

• (7, 5)

• (8, 8)

You can use these coordinates to populate the table. Here's the SQL statement to insert the values into your table:

INSERT INTO Coordinates (x, y) VALUES

(4, 2),

(5, 3),

(6, 4),

(7, 5),

(8, 8);

Me: Unfortunately, ChatGPT has some limitations in extracting values from an X, Y chart. It could not do it.  This may change in the future.

Extracting values from images into T-SQL

Me: I have the following picture of the table:

Please create the T-SQL code to create the table with the data named dbo.salesreason.

ChatGPT:

To create the table dbo.salesreason based on the data provided in the image, you can use the following T-SQL code:

CREATE TABLE dbo.salesreason (

    SalesReasonID INT PRIMARY KEY,

    Name VARCHAR(255),

    ReasonType VARCHAR(255),

    ModifiedDate DATETIME

);



INSERT INTO dbo.salesreason (SalesReasonID, Name, ReasonType, ModifiedDate)

VALUES

(1, 'Price', 'Other', '2008-04-30 00:00:00.000'),

(2, 'On Promotion', 'Promotion', '2008-04-30 00:00:00.000'),

(3, 'Magazine Advertisement', 'Marketing', '2008-04-30 00:00:00.000'),

(4, 'Television Advertisement', 'Marketing', '2008-04-30 00:00:00.000'),

(5, 'Manufacturer', 'Other', '2008-04-30 00:00:00.000'),

(6, 'Review', 'Other', '2008-04-30 00:00:00.000'),

(7, 'Demo Event', 'Marketing', '2008-04-30 00:00:00.000'),

(8, 'Sponsorship', 'Marketing', '2008-04-30 00:00:00.000'),

(9, 'Quality', 'Other', '2008-04-30 00:00:00.000'),

(10, 'Other', 'Other', '2008-04-30 00:00:00.000');

Handle chart images with AI

Now, I will try to get information from the charts

Me: Can you explain to me what this chart means?

ChatGPT:

Provide an analysis of the chart with AI

Me: Based on the chart, do you think the price will increase or decrease this year?

ChatGPT:

Based on the chart you've provided, Bitcoin's price has been on a general upward trend over the last year, with some fluctuations along the way. There has been a noticeable rise, particularly in the recent months, and the chart shows a strong upward trajectory, especially after the dip around mid-2024.

However, predicting the future direction of Bitcoin's price is difficult because the cryptocurrency market is highly volatile, influenced by various factors like market sentiment, global events, regulatory changes, and technological advancements.

Some key observations from the chart:

• Current growth: The price is still relatively high compared to earlier periods, which might suggest continued bullish sentiment.
• Volatility: The chart also shows significant fluctuations, suggesting that the price could experience ups and downs, even within an overall increasing trend.
• Market sentiment: If the current momentum continues, with positive news around adoption or institutional investments, the price could continue to rise. However, any regulatory changes or adverse news could cause the price to dip.

Given this, while the trend seems positive, there is a significant level of uncertainty. If you are considering investing or making decisions based on Bitcoin's price, it might be wise to proceed cautiously and stay updated on market news.

Would you like more insights or help with any specific analysis regarding Bitcoin's price?

Store the data from the chart in a table

Me: Please store the price, marketcap, Volume, FDV, and Total supply from the previous chart into this table:

CREATE TABLE TradingData (

    Id INT IDENTITY(1,1) PRIMARY KEY,       

    Price DECIMAL(18, 8) NOT NULL,            

    MarketCap DECIMAL(18, 2) NOT NULL,     

    Volume DECIMAL(18, 2) NOT NULL,           

    FDV DECIMAL(18, 2) NOT NULL,              

    TotalSupply DECIMAL(18, 2) NOT NULL,      

    Timestamp DATETIME NOT NULL DEFAULT GETDATE() 

);

ChatGPT:

Here is the T-SQL code to insert the data into the TradingData table:

INSERT INTO TradingData (Price, MarketCap, Volume, FDV, TotalSupply)

VALUES 

(84075.27, 1660000000000, 29460000000, 1760000000000, 19830000);

This code will insert the values for Price, MarketCap, Volume, FDV, and TotalSupply into the TradingData table.

Let me know if you need any more adjustments!

Conclusion about the handled images in the AI article

Now the AI is providing not only OCR features to import text from images into SQL Server. Also, the AI can understand charts and do data analysis. AI is simplifying our job of doing data analysis, and soon, we will only need to ask the AI to do our job, and we will only need to organize the information.