August 25, 2014

How to import data into SQL Server using TSQL

There are features such as Import/Export and SQL Server Integration services to get the data into SQL Server. We can get the data directly into SQL Server using SQL command such as
BCP, BULK INSERT, OPENROWSET, OPENDATASOURCE, OPENQUERY and LINKED SERVERS. 

No comments: