python
import pymssql
conn = pymssql.connect(server='localhost', user='username', password='password', database='database_name')
python
cursor = conn.cursor()
python
insert_query = "INSERT INTO students (name, age) VALUES ('John', 25)"
cursor.execute(insert_query)
python
update_query = "UPDATE students SET age = 26 WHERE name = 'John'"
cursor.execute(update_query)
python
delete_query = "DELETE FROM students WHERE name = 'John'"
cursor.execute(delete_query)
python
conn.begin()
try:
cursor.execute(insert_query)
cursor.execute(update_query)
conn.commit()
except:
conn.rollback()
python
cursor.close()
conn.close()
