The prime number 16000057 in object_id creation


I need to find out where this number  was documented  for the usage  to create object_id  in the table sys.sysschobjs primary key id value.

  1. 2013-01-29 (Muhammad Imran): http://raresql.com/2013/01/29/sql-server-all-about-object_id/
  2. 2005-05-25 (Smirnov Anton)  http://www.sql.ru/forum/186926/generirovanie-nomera-obekta-v-baze-dannyh
  3. 2013-11-07 (Sean Pearce)  http://www.sqlservercentral.com/Forums/Topic1512032-391-1.aspx
  
  --Smirnov Anton

if ( curr_id+16000057>=power(2.,31)  )
curr_id=curr_id-2131483591
else
curr_id=curr_id+16000057 ;


 
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s