SQL Server database export table structure and data

Method 1: Directly copy

• After querying the results, right-click on the blank space in the upper left corner and click "Copy along with the title"
  

Method 2: Export Wizard

Path: Database -> Right click on the corresponding database name -> Task -> Export data

Here, select the table name you want to export from the source
Just keep going to the next step afterwards.