python
import pymssql
server = 'localhost'
port = 1433
username = 'sa'
password = 'password'
database = 'mydatabase'
conn = pymssql.connect(server=server, port=port, user=username, password=password, database=database)
cursor = conn.cursor()
def insert_data():
insert_query = "INSERT INTO mytable (name, age) VALUES ('John', 25)"
cursor.execute(insert_query)
conn.commit()
def update_data():
update_query = "UPDATE mytable SET age = 30 WHERE name = 'John'"
cursor.execute(update_query)
conn.commit()
def delete_data():
delete_query = "DELETE FROM mytable WHERE name = 'John'"
cursor.execute(delete_query)
conn.commit()
conn.close()
