Python pymssql get message returned from Database after command is executed

Python is a versatile programming language that can be used to interact with various databases. When working with SQL Server databases, the pymssql library is a popular choice to connect and execute commands. In this tutorial, you will learn how to execute a SQL command using pymssql and retrieve any messages returned by the database.
Before you get started, make sure you have the following prerequisites in place:
Python: Ensure you have Python installed on your system. You can download it from Python's official website.
pymssql: Install the pymssql library using pip by running the following command in your terminal or command prompt:
SQL Server: You should have access to a SQL Server database and the necessary credentials to connect to it.
First, you need to establish a connection to your SQL Server database. You'll need the server name, database name, username, and password to create a connection.
Once the connection is established, you can execute SQL commands using a cursor. You can use the cursor to execute queries, updates, and other SQL commands.
After executing a command, SQL Server might return informational or error messages. You can retrieve these messages using the pymssql library. This is done by calling the messages property of the cursor object.
The cursor.messages property returns a list of messages as tuples, where the first element of the tuple contains the message text.
Here's a complete example: