Calculate object ids with database objects in sql server 2008 arcgis 10.1

Discussion created by jorge.vinagreesri-portugal-pt-esridist Employee on May 12, 2014
Hi there

I was making a little experience with arcgis and sql server 2008 spatial types and I have a couple of doubts.
I imported a shapefile with statistical data to sql server 2008.
Using only SQL Server 2008 native procedures I created another table with the results from unions(STUnion) from the original data.
Since these geometries didn´t exist i could not give them an OBJECTID. Is there any away I can calculate their object id´s using any
function from arcgis so they can constitute a valid layer from the arcgis point of view?