Ah, no, it looks like it's example E. from this page:
https://msdn.microsoft.com/en-us/library/ff878370.aspx
INSERT Test.TestTable (CounterColumn,Name)
VALUES (NEXT VALUE FOR Test.CountBy1, 'Syed') ;
On Mon, Nov 30, 2015 at 10:38 PM, David Durham
<david.durham...@gmail.com> wrote:
> I think your insertString will have something like "insert into
> myTable (...) values (mysequence.nextval, ?,?,?)"
>
> On Mon, Nov 30, 2015 at 9:33 AM, Daniel Price <danprice...@gmail.com> wrote:
>> Hi all. I've been using Groovy to batch insert data into SQL Server, and it
>> works very well. The syntax I've been using is:
>>
>> //batch insert
>> int dbThrottle = 25000
>> db.withTransaction{
>> def result = db.withBatch(dbThrottle, insertString){ ps ->
>> output.each{
>> ps.addBatch(it)
>> }
>> }
>> }
>>
>> This code is used to insert data from list 'output' into my Sql Server DB.
>> The 'insertString' is just the typical insert statement dynamically derived
>> from the target table and columns.
>>
>> I now have a need to use a sequence generator to populate one or more
>> columns in some tables. I can do this by putting sequence numbers in a list
>> and inserting such sequence lists into my 'output' data list, but this is
>> very slow. Is there a way I can include the 'NEXT VALUE FOR' sequence query
>> in the batch insert query so that it is evaluated during batch insert? Will
>> this be any faster?
>>
>> Thanks!
>> D
