Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy Query Results into WORD doc
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01453577
Message ID:
01453591
Vues:
43
I did try the Save Results as... and wonder how I will do the rest of the instructions, as written below.

Here is specifically what she says in her instruction:

Run the query in Management Studio and copy the query result (with the # of rows affected) and paste it below the query in the Word document.

In Word, convert the copied text (query result) to a table by selecting only the query result rows (do not include the blank line and # of rows affected). Then click the Insert Table button from the standard toolbar in Office 2003, or click the Table from the Insert tabl in Office 2007 - Convert Text to Table.

Format the table by adjusting the column width (one line per row, best fit width), and right align only the numeric columns.

>Did you try 'Save Result As' from the File menu?

>>Our teacher for our SQL Server 2008 T-SQL class wants us to copy the Query results into a WORD DOC and then somehow convert it to a WORD table.
>>
>>First of all, I cannot seem to copy the Query results entirely, except with SnagIt and then save it as an image. So, how do I save the text, the record numbers and the Column Names, and then paste it into a WORD DOC and then convert it to a WORD Table? Believe me, I am trying to do this, but the typical, highlight and Copy isn't working.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform