Python and Geocoding

[JayKappy]

I have a stand alone table in SQL server.  I want to create a Python script to Geocode that table.

Can I set up a Geocoder to process that table and place XY coordinates into an XY Field in the table?
It has to process address and intersections. 
I would have three fields House Number, Street, Intersecting Street

Any thoughts, examples on how to get started?

Do I create an mxd with the table in it and save it.
Then write soem python script to point to that mxd and process the Geocode?

Thanks

[JayKappy]

This is what I was trying to explain.
SO it seems that I would have to create a temp table

The Table to Geocode is a Standalone SQL Server table (not SDE)
This would create a Feature Class as output once Geocoded.
Then take the FC and join back to the Standalone SQL Server table to append the XY corrdinates.

Thanks for your thoughts and input.

[BradShore1]

You could make an OLEDB connection to the SQL Server and geocode off of that. Then use the add XY Coordinates tool to get the XY Coordinate you want.