Bulk Import of Data (SQL Server)

Data file for Demonestration of Stored Procedure is in this link  GitHub.

Step 1: Create Database

Step 2: Right click to database created, go to task and to Import Flat File.

Step 3: Click Next

Step 4: Browse the file, give the table name or keep it default and Click next.

Step 5: Preview the data if all you want is correct or not and click next to change table data columns, data type etc.

Step 6: Modify columns.

Step 7:  Click Finish and see summary and click close.

Step 8: Right Click to created database and clic New Query and use SELECT statement to view the table.