Uploading .csv sample table file data to SQL Server
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.