Running a SQL statement in a Microsoft SQL server database
Writing the SQL Server Connection String
If you run Email Parser in the same computer where SQL Server is running the connection string is usually as simple as the one shown in the screenshot above. For building more complex connection strings or if you do not know where to start the best way is to download this tool from Microsoft Technet and then copy the connection string in Email Parser. In that link you can find a step-by-step guide on how to generate one.
Writing the SQL sentence
As Email Parser itself is not a SQL editor it is strongly recommended that you use an external tool to test and build your SQL sentences and later copy them to Email Parser. The most widely used tool for this task is the Microsoft SQL Server management Studio. If you have already installed SQL Server you will probably already have that tool installed but if not you can download it freely from the Microsoft website.
How to include captured text from an email in a SQL sentence?
Email Parser, before running the SQL sentence in the SQL server checks for any field placeholders which are Email Parser specific text looking like this:
When Email Parser finds a placeholder in a SQL sentence it replaces it with the actual field value. This SQL sentence:
INSERT INTO customers (customer_id, customer_address) VALUES ('<%customer_id%>', '<%customer_address%>')
Will be sent to the SQL server like this:
INSERT INTO customers (customer_id, customer_address) VALUES ('8391', '211 Throop Ave, Brooklyn, NY 11206')
What happens with SELECT queries?