You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/connect/python/pymssql/step-1-configure-development-environment-for-pymssql-python-development.md
+6-6Lines changed: 6 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -15,31 +15,31 @@ ms.author: v-daenge
15
15
# Step 1: Configure development environment for pymssql Python development
16
16
You will need to configure your development environment with the prerequisites in order to develop an application using the Python Driver for SQL Server.
17
17
18
-
Note that the Python SQL Drivers use the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No additional configuration is required.
18
+
The Python SQL Drivers use the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No additional configuration is required.
19
19
20
20
## Windows
21
21
22
-
1.**Install Python runtime and pip package manager**
22
+
1.**Install Python runtime and pip package manager.**
23
23
a. Go to [python.org](https://www.python.org/downloads/)
24
24
b. Click on the appropriate Windows installer msi link.
25
25
c. Once downloaded run the msi to install Python runtime
26
26
27
27
2.**Download pymssql module** from [here](https://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql)
28
28
29
-
Make sure you choose the correct whl file. For example: If you are using Python 2.7 on a 64bit machine choose : pymssql‑2.1.1‑cp27‑none‑win_amd64.whl. Once you download the .whl file place it in the C:/Python27 folder.
29
+
Make sure you choose the correct `whl` file. For example: If you are using Python 2.7 on a 64-bit machine choose `pymssql‑2.1.1‑cp27‑none‑win_amd64.whl`. Once you download the `whl` file, place it in the C:\Python27 folder.
30
30
31
31
3.**Open cmd.exe**
32
32
33
-
4.**Install pymssql module**
34
-
For example, if you are using Python 2.7 on a 64bit machine:
33
+
4.**Install pymssql module.**
34
+
For example, if you are using Python 2.7 on a 64-bit machine:
1.**Install Python runtime and pip package manager** Python comes pre-installed on most distributions of Ubuntu. If your machine does not have python installed, you can get either download the source tarball from [python.org](https://www.python.org/downloads/) and build locally, or you can use the package manager:
42
+
1.**Install Python runtime and pip package manager.** Python comes pre-installed on most distributions of Ubuntu. If your machine does not have python installed, you can either download the source tarball from [python.org](https://www.python.org/downloads/) and build locally, or you can use the package manager:
Copy file name to clipboardExpand all lines: docs/connect/python/pymssql/step-3-proof-of-concept-connecting-to-sql-using-pymssql.md
+4-4Lines changed: 4 additions & 4 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -29,7 +29,7 @@ The [pymssql.connect](https://pypi.org/project/pymssql/) function is used to con
29
29
30
30
## Step 2: Execute query
31
31
32
-
The [cursor.execute](https://pypi.org/project/pymssql/) function can be used to retrieve a result set from a query against SQL Database. This function essentially accepts any query and returns a result set which can be iterated over with the use of [cursor.fetchone()](https://pypi.org/project/pymssql/).
32
+
The [cursor.execute](https://pypi.org/project/pymssql/) function can be used to retrieve a result set from a query against SQL Database. This function essentially accepts any query and returns a result set, which can be iterated over with the use of [cursor.fetchone()](https://pypi.org/project/pymssql/).
33
33
34
34
35
35
```python
@@ -45,7 +45,7 @@ The [cursor.execute](https://pypi.org/project/pymssql/) function can be used to
45
45
46
46
## Step 3: Insert a row
47
47
48
-
In this example you will see how to execute an [INSERT](../../../t-sql/statements/insert-transact-sql.md) statement safely, pass parameters which protect your application from [SQL injection](../../../relational-databases/tables/primary-and-foreign-key-constraints.md) value.
48
+
In this example you will see how to execute an [INSERT](../../../t-sql/statements/insert-transact-sql.md) statement safely and pass parameters. Passing parameters as values protects your application from [SQL injection](../../../relational-databases/tables/primary-and-foreign-key-constraints.md).
49
49
50
50
51
51
```python
@@ -61,13 +61,13 @@ In this example you will see how to execute an [INSERT](../../../t-sql/statement
61
61
conn.close()
62
62
```
63
63
64
-
## Step 4: Rollback a transaction
64
+
## Step 4: Roll back a transaction
65
65
66
66
This code example demonstrates the use of transactions in which you:
0 commit comments