Bulk Insert and Temp Tables – Learn With Examples
This example shows how one can use Local and Global Temp Tables. You will know the difference between them in two separate sections. Finally, the example creates text file for Bulk Insert and then shows a T-SQL example which reads this text file & performs bulk insert into the SQL Table.