Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL to Notepad

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2014-11-13 : 02:21:49
Hi All,

Is there a way to create a procedure which can transfer the SQL Data to Notepad with , column identifier. Other than SSIS

Please suggest

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-13 : 08:52:13
you could use xp_cmdshell to call BCP to write the data to a file then call Notepad on that file.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-11-26 : 04:49:26
Refer this http://beyondrelational.com/modules/2/blogs/70/posts/10798/bcp-export-data-to-text-file.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -