SQL Server File Operations?

Question

Using SQL Server 2005: How can I read a file into a SPROC using T-SQL?

So, imagine I have a CSV file like so:

ID,OtherUselessData<br/>
1,asdf<br/>
2,asdf<br/>
3,asdf<br/>

etc...

I basically want to do this:

Select * from mytable where id in (select id from txtFile)

Answer 1

Consider using OPENROWSET function to open/parse you CSV file and use it as a 'row source' (i.e. like a table)

Answer 2

here are some examples: http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/