[Py2.7] sql server 데이터를 csv로 쓰기

/*********************************************************************************************************
-- Title : [Py2.7] sql server 데이터를 csv로 쓰기
-- Reference : gist.github.com/tinybike
-- Key word : pymssql csv 
*********************************************************************************************************/

  
import csv
import datetime
import pymssql
from decimal import Decimal
 
# Connect to MSSQL Server
conn = pymssql.connect ('servername', 'username', 'password', 'dbname')
 
# Create a database cursor
cursor = conn.cursor()
 
# Replace this nonsense with your own query :)
query = """
select top 10 *
FROM dbo.ttt with (nolock)
where skey > 3555555555555
"""
 
# Execute the query
cursor.execute(query)
 
# Go through the results row-by-row and write the output to a CSV file
# (QUOTE_NONNUMERIC applies quotes to non-numeric data; change this to
# QUOTE_NONE for no quotes.  See https://docs.python.org/2/library/csv.html
# for other settings options)
with open("C:\\samples\\ttt.csv", "w") as outfile:
    writer = csv.writer(outfile, quoting=csv.QUOTE_NONNUMERIC)
    for row in cursor:
        writer.writerow(row)
 
# Close the cursor and the database connection
cursor.close()
conn.close()