MSSQL and MySQL
I'm copying tables from MySQL Database to MS SQL Database, but whenever I edit the 'Default' row - choose Auto_Increment (with attributes of: No default value, Custom, NULL, & Auto_Increment) a syntax error shows, "SQL Error (102)" and If I tried it back to No default value. Error will keep shows up. Why is that?
The DEFAULT clause handled by HeidiSQL is mostly MySQL syntax I'm afraid. Read here about setting a column default on MSSQL columns.
Please login to leave a reply, or register at first.