newid() and newsequentialid()

• VM-723206

  SSCrazy

  Points: 2964

  More actions

  September 17, 2009 at 9:31 pm

  #211085

  Comments posted to this topic are about the item newid() and newsequentialid()

• OCTom

  SSChampion

  Points: 11785

  More actions

  September 18, 2009 at 10:00 am

  #1055710

  At the very least, they are spelled differently.

• GabyYYZ

  SSCertifiable

  Points: 7913

  More actions

  September 18, 2009 at 12:30 pm

  #1055805

  As for newsequentialid() not being able to be referenced directly, here's a kluge I've been using (not my idea, but liked it's simplicity):

  -- default to one value returned

  create proc get_newsequentialid

  @numID int = 1

  as

  begin

  create table #my_seq_id(myID uniqueidentifier default newsequentialid())

  declare @cnt int

  set @cnt = 0

  while @cnt < @numID

  begin

  insert into #my_seq_id default values

  set @cnt = @cnt + 1

  end

  select * from #my_seq_id

  drop table #my_seq_id

  end

  go

  Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

• SSSolice

  SSCommitted

  Points: 1907

  More actions

  September 22, 2009 at 1:59 pm

  #1057114

  Inasmuch as they both generate GUIDs, they are the same. The question was somewhat ambiguous