so far I got this is what I've got.
import pyodbc, arcpy
cnxn = pyodbc.connect(trusted_connection='yes', driver='(SQL Server)', server = 'abcserver', database='TEST')
cursor = cnxn.cursor()
try:
query = " SELECT surflat, surflong FROM table1
cursor.execute(query)
cnxn.commit()
except:
print "error"
And I think the next step is to use the arcpy.MakeXYEventLayer_management --> arcpy.CopyFeatures_management into the SDE database. Any pointers on how to do this? TIA