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

[JakeSkinner]

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.

[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.

[JakeSkinner · Accepted solution]

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"