Search against text file

[vc1881]

Hello,

I have a text file with a column of data. How do I search for matching records against a database field?

Thanks,

Victor

 

[mansii]

I believe that you need to read all lines (records) then compare certain filter.

 

[vc1881]

The data in the text file is in the following format:

aaaaaaaaa
bbbbbbbbb
ccccccccc
ddddddddd
eeeeeeeee

what SQL commands would read every line and search against the database?

Thanks

 

[PRPhx]

Do a google search for: read text file sql server. There is a lot of examples out there.

OR you can look into doing a bulk insert of your text file into either a table or temp table.