How to write a SQL script to read contents of a file

I have a SQL script and a ".csv" file. I want the SQL script to read the data from the ".csv" file instead of manually entering the data in the script. Is it possible?

....
.....
......
and SP_F.trade_id = SP_R.trade_id 
and SP_R.iSINCode IN (here is where I can manually enter the data)

ps: I am new to SQL and I am still learning.