Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server MSSQL Export A Table Data To CSV

MSSQL Export A Table Data To CSV

Actually, it is a trick in Microsoft SQL Server Management (or Studio Express) not like mysqldump tool in mysql but it works. Steps below will show you how to export data of a table to a CSV file in Microsoft SQL Server.

1. In Microsoft SQL Server Management, choose a database, right-click on that and then select “New Query”

mssql-select-database

mssql-select-database

2. Type a sql command to get your data which you want to export, something like this:

[sql] select * from Person.Contact
[/sql]

3. Right-click at the result panel and select “Save Results As…”

mssql-export-data-to-csv

mssql-export-data-to-csv

4. Name the file with .csv extension, ex: result.csv

That’s all. You got it!

Mar 17, 2011Hoan Huynh
Import RSS Feed To DiggView Word Wrap In Visual Studio .Net
You Might Also Like:
  • MSSQL Split Function returns table data
  • Export/Import Data From Local Database To Remote Database With MS SQL Server 2008
  • ASP.NET C# Export Data To CSV And Prompt Download
  • MSSQL Trim Function
  • MSSQL Split String Function
  • PHP Connect To MySQL Read Data And Export XML Format
  • Replace String With NText Or Text Data Type In MS SQL Server
  • How To Export Google Analytics Report To PDF Or XML
  • SQL SERVER How to import Text/CSV file into table
  • Delete, Shrink, Eliminate Transaction Log .LDF File
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

10 years ago SQL Servercsv, export485
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
22,195 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
20,069 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
15,845 views
JQuery Allow only numeric characters or only alphabet characters in textbox
13,320 views
C# Read Json From URL And Parse/Deserialize Json
9,815 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Free Online Photo Editor
  • Easy Tips For Writing An Essay
  • What Can I Expect From An Academic Essay Service?

  • Can Be Essay Service Companies Good For You?

  • Tips To Choosing The Ideal Essay Writers
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (28)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (112)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development