Page 1 of 1

Plans for the MS SQL 2012 new sequence feature?

Posted: Sat 31 Mar 2012 08:32
by kurtbilde
Hi,

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

-Kurt

Posted: Mon 02 Apr 2012 14:49
by AndreyZ
Hello,

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

Code: Select all

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

Posted: Tue 03 Apr 2012 07:44
by kurtbilde
Sorry, what I meant was in the TMSTable component... For primary key ect. Like TOraTable does

-Kurt

Posted: Wed 04 Apr 2012 08:40
by AndreyZ
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.