print records from a SQL table?

Question

print records from a SQL table?

Richard Cranston

Hall of Fame

Points: 3680
More actions
March 9, 2004 at 12:56 pm

#101906

What is the easiet way to print records from a SQL table?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

I pretty often pipe the result of a query in QA to a *.csv file and print it with Excel.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 2

run your select and hit CTRL-P once done

Shamless self promotion - read my blog http://sirsql.net

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 3

Richard Cranston

Hall of Fame

Points: 3680

March 10, 2004 at 7:02 am

#498116

How do you "pipe" to a .csv file?

Richard Cranston Hall of Fame Points: 3680 More actions · Answer 4

The CTL-P only printed the select statement, not the results.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

In QA go to Extras-> Options.

Click on the result tab, select the appropriate settings in both combos (Sorry, I have the German version of QA, so i don't know their english equivalent).

Another quick and dirty method is to run statement in QA, place the cursor into the grid CTRL-A, CTRL-C, switch to Excel, CTRL-V.

In the script section I guess you'll find scripts that produce csv files.

HTH

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]