What are the Different ways of importing data into SQL Server?

 Posted by Bandi on 9/10/2013 | Category: Sql Server Interview questions | Views: 2926 | Points: 40

Many approaches are available to import data into SQL Server. Main approaches are:
1) Import and Export Data Wizard  

1.1. Import and Export Wizard tool which comes with SQL Server
1.2. Right-click on Database name --> Tasks --> Import Data option --> follow wizard
2) Using T-SQL script:
2.2. bcp command
3) Hands-on approach
Direct approach from Excel: Place data(records) in the excel and generate INSERT statements by using CONCATENATE() function in excel then run the script in SSMS
Ex: You can use CONCATENATE for the function

4) Using SSIS tasks
NOTE: Mostly I will use 3rd approach for master data INSERT script generation

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Sudheer1414 on: 9/26/2013 | Points: 10
it is nice information and it is used for.net learners.123trainings also provides .netonline training
Posted by: Mywave86ab on: 2/20/2017 | Points: 10
When is the Visual Studio 2017 releasing, in which month as I also want to learn http://hadooptraininginhyderabad.co.in simultaneously?

Login to post response