Lowyat.NET Forums

Welcome Guest ( Log In | Register )

LYN wins Intel-Lenovo-Tangs Blogathon challenge. Thank you everybody!
 
 RSS feedBump TopicReply to this topicStart new topicStart Poll

Outline · [ Standard ] · Linear+

> ms sql export excel/notepad, anyone tried before?

Share on | Track this topic | Email this topic | Print this topic
kokanchai
post Jun 26 2009, 01:48 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #1


Casual
***

Group: Junior Member
Posts: 365
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Dec 2005
From: -----Somewhere Down to Earth-------
hi all,

i am using SQL Server Management Studio Express
i am just curios that,i wanna export some information from the table.after i have selecting out the query

any idea how to i do that?


please guide me~

This post has been edited by kokanchai: Jun 26 2009, 01:49 PM
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
russ
post Jun 26 2009, 03:30 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #2


Newbie
*

Group: Junior Member
Posts: 34
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Jun 2008
select * from (table name)
then copy paste the results returned to notepad

smile.gif
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
aranur
post Jun 26 2009, 04:55 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #3


Regular
******

Group: Senior Member
Posts: 1,491
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Dec 2004
From: Gombak
export as csv file?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
abubin
post Jun 29 2009, 05:36 PM
Show posts by this member only |This post's rating (0+, 0-) | Post #4


Look at all my stars!!
*******

Group: Senior Member
Posts: 4,219
Ratings earned: 0+, 0-
Ratings given: 0+, 0-

Joined: Jan 2003
this is linux thread....smile.gif

and mssql express is free but it is hardly opensource.

This post has been edited by abubin: Jun 29 2009, 05:37 PM
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
« Next Oldest · Linux & Open Source Software · Next Newest »
 

Bump TopicReply to this topicTopic OptionsStart new topic
 



----debug section please ignore----
Lo-Fi Version Time is now: 23rd November 2009 - 01:13 PM
All Rights Reserved 2003-2009 Vijandren Ramadass (~living on a prayer~)
Powered by Invision Power Board(Trial) © 2009  IPS, Inc.