MS SQL Server 2012 & DB Sequence

[rossent]

Hi Servory,

Starting with SQL Server 2012, Microsoft introduced support for database sequences similar to Oracle and PostgreSQL. (http://msdn.microsoft.com/en-us/library/ff878091.aspx)

The jTDS (FreeTDS) driver which we use for MS SQL Server supports SQL Server 2012. (http://jtds.sourceforge.net/)

Can we use now in Servoy the DB Sequence type even for MS SQL Server? (before, only DB Identity was available for MS SQL Server databases)

[ROCLASI]

Hi Rossen,

I don't believe Servoy checks/knows what RDBMS uses DbSequences and which not. It's more up to the JDBC driver to support it.
I suggest you simply test it out and set the Sequence name in the table properties.

Hope this helps.