Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

MSSQL User: got "slapped" on first trying the software

matelot's profile image matelot posted 2 weeks ago in General Permalink

I only use MSSQL. The app has crashed a couple of times (Win10), but never mind that.

I wanted to try the one feature that got my attention: copy table(s) to another DB/server. Got error.

Why is it that HeidiSQL insists on using MySQL syntax (IFNULL) ?

/* SQL Error (102): Incorrect syntax near ','. */ /*!40101 SET SQL_MODE=IFNULL(@OLD_LOCAL_SQL_MODE, '') */;

ansgar's profile image ansgar posted 2 weeks ago Permalink

HeidiSQL is by tradition more a MySQL/MariaDB client, while MSSQL syntax is incompatible with that in quite a few places. The SQL export is one of these.

As a workaround, you could export to clipbboard instead, paste the result somewhere and fix the SQL issues before firing it on MSSQL.

matelot's profile image matelot posted 2 weeks ago Permalink

export to clipbboard

aber bitte :)

You really should add the info to that help page.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.