{"id":226,"date":"2022-03-21T17:57:16","date_gmt":"2022-03-21T16:57:16","guid":{"rendered":"https:\/\/www.panahy.nl\/?p=226"},"modified":"2022-04-05T16:37:48","modified_gmt":"2022-04-05T14:37:48","slug":"getting-started-with-python","status":"publish","type":"post","link":"http:\/\/panahy.nl\/index.php\/2022\/03\/21\/getting-started-with-python\/","title":{"rendered":"Getting started with Python"},"content":{"rendered":"\n

This article is about all you need to setup Python on Windows for a .Net Developer working on Windows using SQL Server.<\/p>\n\n\n\n

Install Latest Python for Windows: https:\/\/www.python.org\/downloads\/windows\/
-> My choice today: 3.10.3 Windows installer (64-bit)<\/a><\/p>\n\n\n\n

Installing Python extension for Visual Studio Code <\/strong>which enables Jupiter Notebook
Installing Python for VSCode <\/strong>which brings syntax highlighting
Installing Python Extension Pack <\/strong>which supports intelliSense
Installing ODBC driver
pip install pyodbc<\/code><\/p>\n\n\n\n

Sample code to run: <\/p>\n\n\n\n

\n
import pyodbc <\/code>\nconn_str = (\"Driver={SQL Server};\"<\/code>\n            \"Server='tcp:myserver.database.windows.net;\"<\/code>\n            \"Database=mydb;\"<\/code>\n            \"UID=sqlUser;\"<\/code>\n            \"PWD=myPassWord;\"<\/code>\n            \"Trusted_Connection=no;\") <\/code>\nconn = pyodbc.connect(conn_str)<\/code>\ncursor = conn.cursor()<\/code>\nsql_str = (\"SET NOCOUNT ON; \\n\"<\/code>\n           \"select * from myTable\"<\/code>\n          )<\/code>\ncursor.execute(sql_str<\/code>)<\/code>\nfor row in cursor:<\/code>\n    print(row)<\/code><\/pre>\n<\/div><\/div>\n\n\n\n
Nice to read more: https:\/\/wiki.python.org\/moin\/BeginnersGuide\/Programmers<\/p>\n\n\n\n
Next: <\/p>\n\n\n\n