Do you copy to excel? #sql #excel #datascience #copy #dataengineering #dataanalytics #sqlserver

preview_player
Показать описание
You're running an ad-hoc query in a Microsoft SQL Server database with SQL Server Management Studio (SSMS) and need to further analyze the result set in an Excel spreadsheet. How do you export the data?

SSMS gives us this option to get our results to Excel:

COPY TO EXCEL - 1. Click the box in the upper left-hand corner of the Results pane to highlight all records
2. Click on Copy with Headers or Ctrl+Shift+C

Open a blank workbook in Excel

1. Right-click
2. Paste

🔥PLEASE LIKE and SUBSCRIBE🔥 - this will boost our motivation to create even more amazing videos.

Be a SQL HERO!

How do you copy to excel ? #sql #excel #datascience #copy #dataengineering #dataanalytics #sqlserver #data
Рекомендации по теме
Комментарии
Автор

When I paste to excel it becomes disorganized, what could be the problem on SQL?

muvhonitshiwalule
welcome to shbcf.ru