Immisa jeer ayaad ku qasbanaatay inaad qof ugu qorto su'aal degdeg ah gudaha SQL Management Studio ka dibna xogta u dhoofiso Excel? Ka Dhoofinta xogta SQL Server waa nidaam cadaalad ah oo dheer waxayna ku lug leedahay dhowr tillaabo, laakiin mar aad sameyso dhowr jeer, ma xuma.

Hal shay oo aan ka bartay badbaadinta natiijooyinka weydiimaha SQL ee qaabka ^(SQL)Excel ama qaabka CSV ayaa ah in ay wanaagsan tahay in la isticmaalo Wizard^{(Export Wizard)} soo dejinta iyo dhoofinta SQL^{(SQL Import)} halkii aad isku dayi lahayd inaad midig-gujiso natiijooyinka oo aad badbaadiso.

Waxaad mar walba xaq u guji kartaa oo dooran kartaa Keydi Natiijooyinka Sida^{(Save Results As)} , si kastaba ha ahaatee, faylka CSV ee aad hesho kuma jiri doono madaxyada tiirka! Tani waa xanuunka boqortooyada haddii aad leedahay 50 tiir.

U Dhoofi Xogta SQL ee Excel

Si aad u dhoofiso xogta SQL habka saxda ah, xaq-guji database-ka (ma aha miiska) oo dooro Hawlaha^(Tasks) , Dhoofinta Xogta^{(Export Data)} .

Marka xigta, waxaad u baahan tahay inaad doorato Isha Xogta^{(Data Source)} . Haddii aad midig-gujisay magaca keydka macluumaadka, markaa wax walba waa inay si toos ah u soo baxaan.

Hadda waxaad u baahan tahay inaad doorato Meesha^{(Destination)} . Horey u soco oo ka dooro Microsoft Excel liiska hoos u dhaca. Taas ka dib, waxaad u baahan doontaa inaad gujiso Browse oo dooro meesha uu ka soo baxayo faylka Excel . Sidoo kale, hubi inaad hayso sanduuqa " Safka kowaad wuxuu leeyahay magacyo tiirar^{(First row has column names)} ".

Marka xigta, waxaad dooran kartaa inaad u dhoofiso dhammaan miis/aragti Excel ama inaad qorto su'aashaada. Xaaladeyda, waxaan u qori doonaa weydiimo gaar ah xogta aan rabo inaan dhoofiyo.

Ku qor su'aalahaaga ka dibna dhagsii Parse si aad u hubiso in wax walba ay sax yihiin.

Ugu dambeyntii, dhagsii Next ka dibna dhagsii dhame^(Finish) . Xogtaada SQL waxaa lagu soo saari doonaa faylka Excel waxaana ku jiri doona dhamaan madaxyada tiirka sidoo kale! Ku raaxayso!

Export SQL Data to Excel with Column Headers

How many times have you had to write up a quick query іn SQL Management Studio fоr someone and then export the data out to Excel? Exporting data from SQL Server is a fairly long procеss and involves several steps, but once you do it a few times, it’s not bad.

One thing I learned about saving SQL query results into Excel format or CSV format is that it’s best to use the SQL Import and Export Wizard rather than trying to right-click on the results and saving them.

You can always right-click and choose Save Results As, however, the CSV file that you get will not contain the column headers! This is a royal pain if you have 50 columns.

Export SQL Data to Excel

To export SQL data the correct way, right-click on the database (not the table) and choose Tasks, Export Data.

Next, you need to choose the Data Source. If you right-clicked on the database name, then everything should come up automatically.

Now you need to choose the Destination. Go ahead and pick Microsoft Excel from the drop down list. After that, you will need to click Browse and choose the location for the output Excel file. Also, be sure to keep the “First row has column names” box checked.

Next, you can either choose to export an entire table/view to Excel or to write your own query. In my case, I will write a specific query for the data that I want to export.

Type in your query and then click Parse to make sure that everything is correct.

Finally, click Next and then click Finish. Your SQL data will be outputted into an Excel file and it will include all the column headers too! Enjoy!

Related posts

• Sida Xogta Loogu Soo Geliyo Xaashiyaha Google-ka Xaashi Kale

• Koobi ka samee Xogta Laptop-ka ama Hard Drive-ka aan la kabi karin

• Si toos ah uga soo celi xogta Excel Bogga Shabakadda

• Sida Loo Isku Xidho Bookmarks Browser & Xogta Firefox & Opera

• Sida Loogu Wareejiyo Xogta Taleefanka Cusub ee Android

• Dib-u-eegis Buugaag - Hagaha sida-Geek-ga loo barto ee Windows 8

• Sida loo soo dejiyo Xogta LinkedIn iyadoo la adeegsanayo Qalabka Dhoofinta Xogta ee LinkedIn

• Sida loo furo faylasha DDS gudaha Windows 10

• Sida loo sameeyo boggaga Master-ka ee Adobe InDesign CC

• Sida Loo Ilaaliyo PC-gaaga Daaqadaha Adigoon taaban Jiirka

• Sida loo furo File quful marka barnaamij kale la isticmaalayo

• Sida loogu dhoofiyo xogta isticmaalka tamarta WeMo Excel

• Sida Loo Sameeyo Qoraalka Miiska Beddelka ah ee SQL

• Sida Loo Dhiso Laabtoobkaaga

• 7 Farsamo Farsamo Kobcinta SEO ee Mareegaha Kasta

• 6 Dejinta kamarada ugu Fiican ee Sawirada Dayaxa

• Sida Loo Soo Celiyo Akoonka Facebook-ga La Jabsado

• Sida loo cusboonaysiiyo Raspberry Pi

• Sida Xogtaga Shakhsiyeed looga soo dejiyo Google

• Sida Loo cusboonaysiiyo Software-kaaga PC si toos ah