Barclays Interview Questions | Import Data

Question

Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?

in progress 0
Dhruv2301 55 years 1 Answer 889 views Great Grand Master 0

Answer ( 1 )

  1. Ognish
    0
    Reply

    Yes, it is possible to import data directly from T-SQL commands without using SQL Server Integration Services. These commands include,

    1. BCP
    2. OpenRowSet
    3. Bulk Insert
    4. OPENQUERY
    5. OPENDATASOURCE
    6. Linked Servers

Leave an answer

Browse
Browse