python怎么连接sql server
时间: 2023-10-11 15:07:14 浏览: 37
要连接SQL Server,需要安装pyodbc模块。然后按照以下步骤进行操作:
1. 导入pyodbc模块
```python
import pyodbc
```
2. 创建连接
```python
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server_name;DATABASE=db_name;UID=username;PWD=password')
```
其中,`server_name`是SQL Server实例的名称或IP地址,`db_name`是要连接的数据库名称,`username`和`password`是连接SQL Server需要的用户名和密码。
3. 创建游标
```python
cursor = conn.cursor()
```
4. 执行SQL语句
```python
cursor.execute('SELECT * FROM table_name')
```
5. 获取查询结果
```python
for row in cursor:
print(row)
```
6. 关闭连接
```python
cursor.close()
conn.close()
```
完整代码示例:
```python
import pyodbc
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server_name;DATABASE=db_name;UID=username;PWD=password')
cursor = conn.cursor()
cursor.execute('SELECT * FROM table_name')
for row in cursor:
print(row)
cursor.close()
conn.close()
```