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.

Error when change length/set in datetime2 column

riookesekali's profile image riookesekali posted 2 months ago in Running SQL scripts Permalink

First of all thank you for your hard work for this amazing software. But I've been getting error whenever changing length in datetime2 column.

SQL Error (102): Incorrect syntax near 'DATETIME2'

I am using SQL server database. I think maybe there is something wrong in generated query?

ALTER TABLE "dbo"."Data Durasi" ALTER COLUMN "start_min" "start_min" DATETIME2(0) NULL DEFAULT NULL; / SQL Error (102): Incorrect syntax near 'DATETIME2'. /

Thanks for your help!

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.