Google News
logo
SQL Server - Quiz(MCQ)
__________ does not allow bulk export operation in SQL Server.
A)
UPDATE
B)
DELETE
C)
INSERT … SELECT
D)
None of the above

Correct Answer :   INSERT … SELECT


Explanation : INSERT … SELECT is a Transact-SQL statement that uses the OPENROWSET bulk rowset provider to bulk import data into a SQL Server table by specifying the OPENROWSET(BULK…) function to select data in an INSERT statement.

Advertisement