Python
Use Python 2 and 3 Pyodbc and Sqlalchemy to connect to SQL Server Client 11.0
There are several ways you can use Python to connect to SQL Server and one of such ways is to
April 18, 2021
No Comments
SQL
Pyodbc Sqlalchemy Python 2 and 3 SQL Server Native Client 11.0
This is a sample code to use Python to connect to SQL Server Native Client.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
import sqlalchemy import pyodbc try: import urllib params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=MagicDirect;Trusted_Connection=yes;") engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params) results.to_sql("clusterSegments", engine, if_exists = 'replace')# except (RuntimeError, TypeError, NameError): print('Error in Conneccting') print(RuntimeError, TypeError, NameError) finally: print("connected") |
April 18, 2021
No Comments
Data Warehousing
Free Entity Relationship and Relational Schema Diagram Tool
ERDPLUS One tool I generally use when working on a projects, mini tasks and exploration is the ERDPLUS tool .
November 27, 2016
No Comments
Using Subqueries To Join 2 More Tables Which Do Not Have Unique Primary and Foreign Keys
Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find
November 12, 2016
No Comments
Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
Sometimes, you would want to split values in a column into separate rows in SQL server. This is a simple
November 3, 2016
No Comments
Get Numbers and Percentages from Tables – Microsoft Sql Server
Sometimes you want to get some numbers and also percentages for quick analysis. This is a quick simple way to
October 2, 2016
No Comments
SQL
Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts
August 7, 2016
No Comments
DataPandas LTS
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs