Bulk Copy from Table Variable

sql sqlbulkcopy

Question

Is it possible to use BulkCopy for copying data from a table variable to Real table (SQL table) where both schema are identical?

Popular Answer

Try this

select * into RealTable from yourTableVariable



Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why