Add MS SQL Server Dialect about exposed HOT 10 CLOSED

Sorry, but we don't have enough experience with MSSQL and MSSQL Compact for unit test, so if have - please PR SQLServerDialect. You can find examples in H2.kt, Mysql.kt

from exposed.

I added support for MSSQL in https://github.com/YakovSirotkin/Exposed/tree/sqlserver-dialect, but I want to wait with pull request until clarification with #155

Testing with Docker is not trivial and maybe it will be possible to re-use approach for Oracle tests to SQL Server.

from exposed.

I created pull request #164 with SQL Server support, but I am not sure about Docker tests. Maybe it makes sense to create one tests with 2 Docker instance with Oracle and SQL Server.

from exposed.

Ok, I will check PR next week and will try to setup single TC configuration to run both DBMS.

from exposed.

Would be great to get MS SQL support in Exposed. We're about to start integrating our services with our Azure backend. Happy to help with testing/validation if that's of benefit.

from exposed.

@Tapac Do you have a plan how to add SQL Server support? Maybe we can create branch in main repo from #164 (comment)? At least it will be easier to keep branch up-to-date.

from exposed.

@YakovSirotkin, finally I'm ready to merge your branch with SQLDialect into master and create a release.
First of all, thank you for that PR, and let me know you have an account at kotlinlang.slack.com, because I want to mention you in release announce in the Exposed channel.

Also, I found out that DATETIME2 type doesn't have that problem with losing millis.

from exposed.

@Tapac thanks a lot for all your work! I think that I don't have account at kotlinlang.slack.com because I don't have email at jetbrains.com:)

from exposed.

@YakovSirotkin , I'm not sure that it's required to, but sent you invitation to @telamon.ru anyway .

from exposed.

@Tapac, thanks a lot, I just registered.

from exposed.