In Workload Analysis, when you right click on a SQL statement, copy then paste into an external editor like notepad because you don’t have SQL Server Management Studio on your local desktop, the SQL statement will copy in SQL format into a Notepad doc. However, when you click the Copy button in left hand corner of the Statement in Workload Analysis, it gets copied over in HTML format.
Listed below is a screenshot of what I’m talking about. The top Notepad doc is when you right click on a statement and view in external editor and the bottom Notepad doc is when you use the copy button. The yellow highlighted areas is what I’m talking about.