Loading ...

SQL Server:Export query results to CSV

Who is online?  0 guests and 0 members
home  »  blogs  »  Raghav Khunger  »  SQL Server:Export query results to CSV

SQL Server:Export query results to CSV

(0)
(7218)
0
/5
Avg: 0/5: (0 votes)

posted 2/9/2011  by Raghav Khunger

In this blog I will show how to export the query results to CSV file in SQL server 2008. Today I was having this requirement where I need to export my results to CSV file, I decided to write a blog on it. Below are the few steps which will lead you to export it.

Steps

1. Run the query in SSMS whose results you want in CSV format.



2. Right click over the Query Window and select "Save Results As.." from the context menu.



3. Give the file name from your CSV file and press the Save button.



That's it CSV file has been saved at the specified location. Below is the output of the file which is just created.



Hope this helps!

 tags: export query results to csv, sql server export query results to csv

Product Spotlight

ASP.NET Hosting Spotlight
 

Comments (no comments yet)

Add a new comment

Confirm

Latest community blog posts

  • jQuery Tools Tabs: Tab index lost on postback
    yesterday by Raghav Khunger
    A person on the forums was struggling with jQuery tools tabs index issue on postback. On clicking the tabs and doing some postback the selected tab index was getting lost. Below is the solution on how to retaing the previous selected index which was there before postback. Complete Source: <%@ Pag...
  • jQuery Tools Tabs: Set initial selected index by default
    yesterday by Raghav Khunger
    I was working with jQuery tools tabs today and I had to set the initial index of tab selected by default. The solution is to set initialindex property in the options. Source: $("ul.tabs").tabs("div.panes > div", { initialIndex: 1 }) ; Complete code to test above: <html> <head> <tit...
  • ASP.NET: Get formauthentication cookie and get the data present in it
    3 days ago by Raghav Khunger
    A person asked me today how to get form authentication cookie and get the data present in it. I decided to write a short blog on it. Formauthentication cookie is saved with the name which we can get via FormsAuthentication.FormsCookieName property. The key here is to get the cookie via this name and...
  • ASP.NET: Form authentication timeout in web.config overriding the manual ticket timeout
    13 days ago by Raghav Khunger
    While working with one of the sample application I noticed that form authentication timeout in web.config was overriding the manual ticket's (which we created via code) timeout. Below is the code which was written in the application: var ticket = new FormsAuthenticationTicket(1, "UserName", DateTime...
  • jQuery: Set cursor position in textbox
    4/13/2012 by Raghav Khunger
    In this blog I will show how to select a range of characters in textbox with jquery. In my demo I have used one textbox and one button. On click of button arange of characters in textbox will be selected. Below is the sample code: <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="ser...

Raghav Khunger's latest blog posts

Product Spotlight

ASP.NET Hosting Spotlight

 

Quick Vote

What kind of email newsletter would you prefer to receive from CodeAsp.Net?