How to Connect to MSSQL Database and Run SQL Queries in UiPath



Do you want to connect your UiPath RPA bot to a Microsoft SQL Server Database? This video will guide you through all steps, including the creation of a database table.

Link to download SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Link to download SQL Server Managament Studio: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

All SQL queries mentioned in the video (so you can paste them):
06:44 – “SELECT * FROM students”
09:00 – “SELECT * FROM students WHERE country=’UK'”
09:48 – “SELECT * FROM students WHERE country='”+country+”‘”
10:35 – “SELECT * FROM students WHERE country=@country”