SQL Query, is it possible to export the results on the fly?

Question

I am using the query below to get some result but I would like it to be exported to a csv. Is this possible with headers too?

Select 
 sys.Netbios_Name0, 
 sys.User_Domain0, 
 sys.User_Name0, 
 sys.Operating_System_Name_and0, 
 arp.DisplayName0,
 ARP.Version0
FROM 
 v_R_System sys
 JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID 
WHERE 
 Displayname0 like '%Adobe Reader%'

Run the query in SQL Server Management Studio and you can export the grid to a csv file. — Gordon Linoff, Jul 01 '15 at 13:57
possible duplicate of [Export query result to .csv file in SQL Server 2008](http://stackoverflow.com/questions/3169220/export-query-result-to-csv-file-in-sql-server-2008) — Tab Alleman, Jul 01 '15 at 14:00

Neeraj Dubey · Accepted Answer · 2015-07-01T16:38:27.263

1

Hey you can try Openrowset in SQL

INSERT INTO OPENROWSET 
('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=c:\Test.xls;HDR=YES','Select 
 sys.Netbios_Name0, 
 sys.User_Domain0, 
 sys.User_Name0, 
 sys.Operating_System_Name_and0, 
 arp.DisplayName0,
 ARP.Version0
FROM 
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID WHERE 
Displayname0 like ''%Adobe Reader%''')

Hope it helps you

edited Jul 01 '15 at 16:38

answered Jul 01 '15 at 14:01

Neeraj Dubey

4,401
8
30
49

It is missing my WHERE? – user1342164 Jul 01 '15 at 14:34

SQL Query, is it possible to export the results on the fly?

1 Answers1