nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

insertRow into SQL server

AlexandreDinnouti

I would like to insert an multidimensional array of points into a dataset stored in a SQL Server. Do you guys have a sample code showing how to connect and insertRow?

thanks
Alex

Trouver plus de publications taguées avec

Accepted answers

jskinner

Yes, you can use the InsertCursor with an SDE connection file. Just set your env.workspace variable to wherever your .sde file is. Ex:

import arcpy from arcpy import env env.workspace = r"Database Connections\GIS.sde"

All comments

jskinner

Yes, you can use the InsertCursor with an SDE connection file. Just set your env.workspace variable to wherever your .sde file is. Ex:

import arcpy from arcpy import env env.workspace = r"Database Connections\GIS.sde"

AlexandreDinnouti

I saw examples of InsertCursor (arcpy.da) being used to point to a system path, but never to an SQL Server. Is that possible?

thanks,
Alex.

jskinner

If you are looking to insert a row into a SQL Server table, take a look at the ArcSDESQLExecute class. If you are looking to insert a row into an SDE geodatabase table, you can use the InsertCursor function.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.