How To Export Data From SSMS To CSV in 2023 | # 008
Автор: LA Data Nerds
Загружено: 2023-10-18
Просмотров: 1585
Описание:
Source of Sample Data:
https://www.kaggle.com/datasets/perkymaste...
In this video, we will show you how to export data from SSMS SQL Server to a CSV file. The data gathered was from an open source database ex. Kaggle.
If you're a beginner, this is perfect for you and if you're a seasoned pro, send this to someone looking to get started.
Steps:
1.) Connect to Database → Tasks → Export Data
2.) Choose Data Source → Microsoft OLE DB Driver for SQL Server → Properties → Enter Server Name, Username and Password. Select Database to Export From → OK
3.) Choose Destination → Pick Flat File Destination → Have a blank .csv file ready for export → Debugging Errors
4.) Debugging Errors → Enable Unicode → Next
5.) Check the Exported .csv file
If you are interested in learning more about Azure SQL, please subscribe to our channel for more videos!
Previous Video #007: • How to Export Data From SSMS To Excel in 2...
Next Video #009: • Creating a Local Database in SSMS in 2023 ...
#sqlserver2023 #becomingadatabaseadmin #sql #sqlserver
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: