Select to view content in your preferred language

Attribute Assistant - Getting GENERATE_ID in SQL Server

415
2
02-11-2022 03:56 AM
Jyotirmoy
New Contributor

Hi,

I am trying to figure out How to get the GENERATE_ID value through SQL Server. Please anyone knows how to get it or implemented such scenario. 

Please help. Thanks!

Tags (1)
0 Kudos
2 Replies
KimGarbade
Regular Contributor

I'm sure you've seen this, but just in case.....  It looks like you would add a row to the "Generate ID" table:  

https://solutions.arcgis.com/shared/help/attribute-assistant/workflows/configure-generate-id-table/

If attribute assistant is set up on an SQL database that probably runs Create Sequence in your SQL GDB

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-v....

0 Kudos
Jyotirmoy
New Contributor

Thank you Kim,

Yes. I have checked the links you have shared. But I want to use the existing SEQNAME in SQL queries inserts. 

Why because there should not be clash between ID generated by SQL and ArcMap Attribute Asst.

0 Kudos