topic Re: insertRow into SQL server in Python Questions https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256588#M19750 <HTML><HEAD></HEAD><BODY><SPAN>Yes, you can use the InsertCursor with an SDE connection file.&nbsp; Just set your env.workspace variable to wherever your .sde file is.&nbsp; Ex:</SPAN><BR /><BR /><PRE class="plain" name="code">import arcpy from arcpy import env env.workspace = r"Database Connections\GIS.sde"</PRE><DIV style="display:none;"> </DIV></BODY></HTML> Tue, 20 Aug 2013 12:07:46 GMT JakeSkinner 2013-08-20T12:07:46Z insertRow into SQL server https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256585#M19747 <HTML><HEAD></HEAD><BODY><SPAN>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?</SPAN><BR /><BR /><SPAN>thanks</SPAN><BR /><SPAN>Alex</SPAN></BODY></HTML> Tue, 20 Aug 2013 08:35:09 GMT https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256585#M19747 AlexandreDinnouti 2013-08-20T08:35:09Z Re: insertRow into SQL server https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256586#M19748 <HTML><HEAD></HEAD><BODY><SPAN>If you are looking to insert a row into a SQL Server table, take a look at the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//002z00000021000000">ArcSDESQLExecute</A><SPAN> class.&nbsp; If you are looking to insert a row into an SDE geodatabase table, you can use the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//018w0000000t000000">InsertCursor</A><SPAN> function.</SPAN></BODY></HTML> Tue, 20 Aug 2013 10:23:42 GMT https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256586#M19748 JakeSkinner 2013-08-20T10:23:42Z Re: insertRow into SQL server https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256587#M19749 <HTML><HEAD></HEAD><BODY><SPAN>I saw examples of InsertCursor (arcpy.da) being used to point to a system path, but never to an SQL Server. Is that possible?</SPAN><BR /><BR /><SPAN>thanks,</SPAN><BR /><SPAN>Alex.</SPAN></BODY></HTML> Tue, 20 Aug 2013 12:04:05 GMT https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256587#M19749 AlexandreDinnouti 2013-08-20T12:04:05Z Re: insertRow into SQL server https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256588#M19750 <HTML><HEAD></HEAD><BODY><SPAN>Yes, you can use the InsertCursor with an SDE connection file.&nbsp; Just set your env.workspace variable to wherever your .sde file is.&nbsp; Ex:</SPAN><BR /><BR /><PRE class="plain" name="code">import arcpy from arcpy import env env.workspace = r"Database Connections\GIS.sde"</PRE><DIV style="display:none;"> </DIV></BODY></HTML> Tue, 20 Aug 2013 12:07:46 GMT https://community.esri.com/t5/python-questions/insertrow-into-sql-server/m-p/256588#M19750 JakeSkinner 2013-08-20T12:07:46Z