How to import data directly from T-SQL commands without using SQL Server Integration Services?

There are so many ways to import data directly using T-SQL.

Here listed couple of commands which helps to load the Data quickly into the Database:

• BCP
• Bulk Insert
• OpenRowSet
• OPENDATASOURCE
• OPENQUERY