Oprava chyb v SQL příkazech stažených ze StackOverflow

Abstract

The main topic of this bachelor thesis is to create a tool that automatically corrects the most common errors in SQL statements. Eleven fixes related to the DML SELECT statement are implemented, which resulted from the analysis of the most common errors. In this work, we worked with a data collection from the StackOverflow website, which contains various questions and answers, mostly of technical type. The result is a tool working in two closely related modes. The first one allows you to retrieve the necessary records from the data collection, the second one focuses on individual SQL statement fixes with the MSSQL dialect.