Is it possible? Allocate Identity values before performing insert

• Jeff Moden

  SSC Guru

  Points: 1004340

  More actions

  July 12, 2023 at 7:24 pm

  #4233501

  I don't know who marked that last post as spam but, I agree with it.  I got a copy of the post and it was pretty obvious that someone was trying to generate a presence without any useful content by posting something generated by a chat bot (a.k.a. Automatic BS Grinder).  And, nope... it wasn't me.

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• July 13, 2023 at 6:41 am

  This was removed by the editor as SPAM

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  July 13, 2023 at 7:40 am

  #4233942

  aztec_2step wrote:

  Using a sequence, can a process get a set of 5000 values

  How to return multiple sequence numbers with sp_sequence_get_range - Simple Talk (red-gate.com)

• July 13, 2023 at 8:05 am

  This was removed by the editor as SPAM

• July 15, 2023 at 7:28 am

  This was removed by the editor as SPAM

• July 17, 2023 at 8:50 am

  This was removed by the editor as SPAM

• July 17, 2023 at 4:05 pm

  This was removed by the editor as SPAM

• July 19, 2023 at 1:13 pm

  This was removed by the editor as SPAM

• July 21, 2023 at 8:53 am

  This was removed by the editor as SPAM

• July 28, 2023 at 1:06 pm

  This was removed by the editor as SPAM

• July 31, 2023 at 1:34 pm

  This was removed by the editor as SPAM

• August 6, 2023 at 1:54 pm

  This was removed by the editor as SPAM

• August 7, 2023 at 11:18 am

  This was removed by the editor as SPAM

• September 2, 2023 at 12:35 pm

  This was removed by the editor as SPAM

• September 2, 2023 at 1:16 pm

  This was removed by the editor as SPAM