Export as SQL

[expired user #9864]'s profile image [expired user #9864] posted 8 years ago in General Permalink

Hello export from MSSQL database to sql file for tables with datetime field can cause on execution error in localyzed version of MSSQL server (italian for example). Isuggest two simple solutions :

  1. use ISO 8601
  2. use SET DATEFORMAT YMD before the string representing the datetime Thank you

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