SQLTeam.com | Weblogs | Forums

Data insertion in temp table



I want to create a temporary table and add 2000 zipcodes in it. I do have list of zipcodes. But i dont know how do i add to table. If i manually di, It gonna take long time.


Where is the "list of zipcodes" you have? If that's in a text file or spreadsheet, you can load that into SQL Server without having to enter them yourself.