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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Writing data to a file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-03-05 : 07:50:37
Randy writes "My question is.

1. Using T-SQL, how can i select data from a table and write the output to a file with datestamp on it.

Sample(Select): select ename, dept, address from emp;
Output file: c:\mydata20040123.txt - this file will containt the records selected."

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-05 : 07:52:23
Have a look a the following article:

http://www.sqlteam.com/item.asp?ItemID=4722
Go to Top of Page
   

- Advertisement -