My supervisor asked me to import data in an Excel file into SQL Server. I remembered that I had ever successfully imported Excel file via the tool provided by SQL Server itself. So I accepted the task.
However, the format my supervisor wanted in SQL Server was very different from the Excel file. Another colleague recommended me to write a temporary program which could control exactly data and move them into SQL Server. This seemed reasonable, but debugging and testing the program would take time.
I asked Deepseek how to use the tool in SQL Server to do that, and perfectly completed the task according to its steps with just a few lines of SQL.
AI can indeed help us and improve our work, but the key point is knowing what and how to ask it.
网友评论