Hi Tanuj Kumar,
To import data from csv file in SQL Server, you have to use BULK Query Command. Let's take look of Bulk Query Command query.

Query:  

BULK INSERT tbl_Name
               FROM 'csvFileNamewith Path'
                  WITH 
                     (
                        FIELDTERMINATOR = ','
                     )