distal-attribute
distal-attribute
distal-attribute
distal-attribute

Single quote in double hyphen Comment line breaks the comment

xpectworld posted 4 months ago in General

I'm moving from the bloadware that is SSMS (thanks for HS BTW guys)

I paste a single stored procedure in and half of it is green and looks like a comment.

The reason is the ' single quote.

e.g.,

--Glo demo DB id's only update customer set name = 'Ashley Bethany', deleted = 0 where id = 54

Just doing my bit...

Misha v.3 posted 4 months ago

Strings started with double hyphens are comments in MySQL so I do not see any issues here.

kalvaro posted 4 months ago

SQL editor is some third-party component that's mainly suited to MySQL so there're glitches like this, not sure if there's an easy fix.

In any case, don't drop SSMS yet. HeidiSQL is handy but quick lookups but SQL Server support is rather experimental.

Please login to leave a reply, or register at first.