https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1143035#M6166 <P>I'm sure you've seen this, but just in case.....&nbsp; It looks like you would add a row to the "Generate ID" table:&nbsp;&nbsp;</P><P><A href="https://solutions.arcgis.com/shared/help/attribute-assistant/workflows/configure-generate-id-table/" target="_blank">https://solutions.arcgis.com/shared/help/attribute-assistant/workflows/configure-generate-id-table/</A></P><P>If attribute assistant is set up on an SQL database that probably runs Create Sequence in your SQL GDB</P><P><A href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15#:~:text=A%20sequence%20is%20a%20user,restart%20(cycle)%20when%20exhausted" target="_blank">https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15#:~:text=A%20sequence%20is%20a%20user,restart%20(cycle)%20when%20exhausted</A>.</P> Fri, 11 Feb 2022 13:57:15 GMT KimberlyGarbade 2022-02-11T13:57:15Z https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1143012#M6165 <P>Hi,</P><P>I am trying to figure out How to get the&nbsp;GENERATE_ID value through SQL Server. Please anyone knows how to get it or implemented such scenario.&nbsp;</P><P>Please help. Thanks!</P> Fri, 11 Feb 2022 11:56:43 GMT https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1143012#M6165 Jyotirmoy 2022-02-11T11:56:43Z https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1143035#M6166 <P>I'm sure you've seen this, but just in case.....&nbsp; It looks like you would add a row to the "Generate ID" table:&nbsp;&nbsp;</P><P><A href="https://solutions.arcgis.com/shared/help/attribute-assistant/workflows/configure-generate-id-table/" target="_blank">https://solutions.arcgis.com/shared/help/attribute-assistant/workflows/configure-generate-id-table/</A></P><P>If attribute assistant is set up on an SQL database that probably runs Create Sequence in your SQL GDB</P><P><A href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15#:~:text=A%20sequence%20is%20a%20user,restart%20(cycle)%20when%20exhausted" target="_blank">https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15#:~:text=A%20sequence%20is%20a%20user,restart%20(cycle)%20when%20exhausted</A>.</P> Fri, 11 Feb 2022 13:57:15 GMT https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1143035#M6166 KimberlyGarbade 2022-02-11T13:57:15Z https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1144007#M6168 <P>Thank you Kim,</P><P>Yes. I have checked the links you have shared. But I want to use the existing <SPAN>SEQNAME in SQL queries inserts.&nbsp;</SPAN></P><P><SPAN>Why because there should not be clash between ID generated&nbsp;by SQL and ArcMap Attribute Asst.</SPAN></P> Tue, 15 Feb 2022 12:56:21 GMT https://community.esri.com/t5/developers-questions/attribute-assistant-getting-generate-id-in-sql/m-p/1144007#M6168 Jyotirmoy 2022-02-15T12:56:21Z