Can Microsoft Copilot Write Simple SQL Commands for You?


According to the claims made by big technology business, generative expert system platforms like Microsoft Copilot will make the working lives of individuals at all levels of a company more productive and effective. However is that just embellishment, or do the claims have some merit?

For example, can the free variation of Microsoft Copilot, offered to all Windows users, compose a common SQL inquiry for you on command? That capability would be incredibly helpful for a time-constrained, less-experienced employee attempting to fulfill a deadline. Below, we explore what takes place when we ask Microsoft Copilot for some SQL aid.

DOWNLOAD: AI fast glossary from TechRepublic Premium

Testing Microsoft Copilot’s capability to compose simple SQL commands

For our experiment, we began with something basic and simple. Utilizing Creative mode, we asked Microsoft Copilot for the code needed to develop a table in SQL called Staff member that included four columns: EMP_ID, Call, Salary, Age. The AI supplied this code:
PRODUCE TABLE Staff Member (

Call VARCHAR( 100 ),
Income DECIMAL(10, 2),


You can see the prompt and code in Figure A.

Asking Microsoft Copilot how to create a simple SQL table. Figure A: Asking Microsoft Copilot how to create a basic SQL table. Image: Mark W. Kaelin While this code would likely require tweaking depending upon your specific needs, in general, the code was precise and useful based upon what was asked of Copilot. Note the description provided by Microsoft Copilot as well; it is as crucial as the code:”This declaration defines EMP_ID as an integer and the main key for the table, Name as a variable character string with an optimum length of 100 characters, Wage as a decimal with 10 digits in total and 2 digits after the decimal point, and Age as an integer. Adjust the information types and sizes according to your particular requirements.”

Continuing our session with Microsoft Copilot, we then asked the AI to generate the code needed to insert a brand-new record into this table. The resulting code is listed below:

PLACE INTO Staff Member (EMP_ID, Name, Income, Age) WORTHS (1, ‘John Doe’, 55000.00, 30);

You can see the prompt and code in Figure B.

Asking Microsoft Copilot how to insert a record into a SQL table. Figure B: Asking Microsoft Copilot how to place a record into a SQL table. Image: Mark W. Kaelin The VALUES area would require to be modified for your particular requirements, but the code and the explanation offered by Copilot were precise and useful. It is very important to keep in mind that as soon as our table of workers is complete, we might be tasked with composing queries to pull data from our database.

Next in our session with Microsoft Copilot, we asked the AI to generate the code necessary to note workers from this table with a particular age or greater. In this case, Microsoft Copilot recommended this code.

PICK * FROM Worker WHERE Age >= 30;

You can see the timely and code in Figure C.

Figure C: Asking Microsoft Copilot to select records from a SQL table. Image: Mark W. Kaelin Figure C: Asking Microsoft Copilot to pick records from a SQL table. Image: Mark W. Kaelin Again, while you may need to adjust the code for your specific requirements, this code was accurate and beneficial for workers less acquainted with SQL syntax.

So, when asked properly, Microsoft Copilot can write fundamental SQL code for your employees. However, whatever answers are generated by Copilot needs to constantly be inspected for applicability and accuracy.

DOWNLOAD: AI vs machine learning distinctions and utilize cases from TechRepublic Premium

Microsoft Copilot resources from TechRepublic

What have we learnt more about Microsoft Copilot and SQL code generation?

We can draw these conclusions from our try out Microsoft Copilot:

  • Under the right conditions, and when asked the ideal questions, Copilot can supply useful and precise SQL commands that workers can apply to their work jobs.
  • The totally free version of Microsoft Copilot derives its “understanding” by modeling data from Bing searches and the web. Tutorials discussing standard SQL commands and using SQL pointers prevail on the web. Those two conditions mean asking Copilot about SQL commands returns is most likely to return beneficial responses. However, asking about subjects not common or not checked out on the internet may not be as effective.
  • Depending on information generated from the web for service decisions can be a dangerous activity. The internet is notorious for incorrect and misleading details, and answers provided by Microsoft Copilot, in particular circumstances, could be polluted by these mistakes.
  • Even if the responses provided by Microsoft Copilot are useful, they still need to always be vetted and filtered by workers for accuracy and applicability. While generative AI can be a powerful tool, it must seldom be trusted with making decisions or acting on its own.
  • Among the most effective elements of Microsoft Copilot sessions is the AI’s ability to repeat responses. In our example, we had the ability to use Copilot’s previous responses to our questions as a fundamental basis for our next questions. This capability permits workers to have a conversation with the AI and then construct toward the most precise and useful response.
  • Our example likewise shows that the more comprehensive the concern sent to Microsoft Copilot, the more precise the produced response. By including variable names, Copilot had the ability to provide total answers and not simply basic SQL command pointers. The ability to formulate in-depth questions is what separates a simple search from a beneficial Copilot session.
  • Utilizing Microsoft Copilot needs an adjustment in thinking by staff members looking for to use it as a work tool. Copilot is not simply another search engine, and it ought to not be approached that way. Essentially, staff members are asking Copilot to read and translate info offered on the internet for them and then present helpful, accurate and viable answers to their questions. The questions workers ask of Copilot will be essentially different from the questions they ask of a fundamental online search engine.

Should employees rely on Microsoft Copilot for work tasks?

We have actually proven that Microsoft Copilot can be a beneficial performance tool for your workers, but just if it is utilized correctly. Employees must recognize that Copilot, and any other generative AI platform, is not just another online search engine. Questions sent to Copilot needs to be considered, comprehensive and specific. The more detailed the concern, the more detailed the answer. Employees must likewise realize that the first question is frequently just the foundation that causes a better and informing discussion with Copilot.


Leave a Reply

Your email address will not be published. Required fields are marked *