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
 SQL Server Development (2000)
 How to open text file by using sql query

Author  Topic 

Tiwari
Starting Member

18 Posts

Posted - 2002-07-11 : 04:37:51
How to open text file by using sql query?

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-07-11 : 04:42:58
If you want to get the data from a text file into a table, try
- bcp, or
- bulk insert

If you want to execute the contents of a text file as sql statements, try osql.

Lookup the syntax in BOL
Go to Top of Page
   

- Advertisement -