Bulk Copy from Table Variable

Question

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

insert into ... select from .... – Mitch Wheat Feb 13 '14 at 07:04 — Mitch Wheat, Feb 13 '14 at 07:04

Akshay · Answer 1 · 2014-02-13T07:13:48.283

0

Are you looking for this

insert into realTable(col1,col2) select t1.col1,t1.col2 from variableTable as t1

edited Feb 13 '14 at 07:13

answered Feb 13 '14 at 07:05

Akshay

score 0 · Answer 2 · answered Feb 13 '14 at 07:09

0

Try this

select * into RealTable from yourTableVariable

answered Feb 13 '14 at 07:09

Krishnraj Rana

what about bulkcopy?, i need bulk copy not row insert – Binu Bhasuran Feb 13 '14 at 07:40

2 Answers2