Plans for the MS SQL 2012 new sequence feature?

kurtbilde · Post by **kurtbilde** » Sat 31 Mar 2012 08:32

Hi,

Any plans for support for new MS SQL 2012 sequence feature?

-Kurt

AndreyZ · Post by **AndreyZ** » Mon 02 Apr 2012 14:49

Hello,

If you are using SQL Server 2012, you can work with sequences using SDAC. Here is a code example:

MSConnection.ExecSQL('CREATE SEQUENCE Seq1 AS INT START WITH 1 INCREMENT BY 1 MAXVALUE 1000 NO CYCLE CACHE 10', []);

kurtbilde · Post by **kurtbilde** » Tue 03 Apr 2012 07:44

Sorry, what I meant was in the TMSTable component... For primary key ect. Like TOraTable does

-Kurt

AndreyZ · Post by **AndreyZ** » Wed 04 Apr 2012 08:40

We will investigate the possibility of adding such functionality. You can also leave your suggestion at our UserVoice page ( http://devart.uservoice.com/forums/1046 ... components ), and if there are many votes for your suggestion, we will implement it faster.