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:
01453582
Vues:
38
>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.

Select your query, right click, Select All, right click again, and then use Copy (with headers) and then paste into the Word.

Below is an example.
id	FirstColumn	LastColumn	SomeNumber	NewValue
1	A	B	10	10
2	C	D	20	30
3	E	F	30	60
4	G	H	40	100
The headers don't look aligned here in the messages area.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform