Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.

Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.

In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.

In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.

Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt HoverOver popups.

The SQL text shows the problem. Run the script then come in and hover over the OrderID and OrderItemID fields in the different places in the SELECTs.

HoverOver1.png shows how it looks on the Inner most SELECT. Both are Int.
HoverOver2.png shows how it looks on the Outer most SELECT. Microsoft is varchar and SQL Prompt is Int.