SQL Server query Results export Excel

1. Right-click Database-"task--" Export data, open the SQL Server Import and Export Wizard;

2. Select the current database, fill in the user name, password, next;

3. Select the target type Excel, select Export template, next step;

4. Select Write query to specify the data to transfer (W), you can press W directly, the next step;

5. Write the query SQL statement, click the analysis detection statement, the next step;

6. Edit the mapping relationship, preview the effect, next;

7. Next, to completion;

Note: This method resolves a long numeric string, such as a social security number, that is automatically converted into a digital type in Excel when the query results are copied directly, resulting in incorrect display.

SQL Server query Results export Excel