Showing posts with label physical. Show all posts
Showing posts with label physical. Show all posts

Sunday, March 11, 2012

Bulk Insert from Memory (without using physical file)

Greetings,
In SQL Server (7, 2000), can we bulk insert data from a data structure
(any possible kind) from the memory without using physical file as
source.
Thanks in advance,
Don
*** Sent via Developersdex http://www.examnotes.net ***For SQL Server 2000 you can bulk load XML from
a stream using the SQLXMLBulkLoad COM object.
Also you can use the 'C' callable bulk
load API (bcp_init/bcp_bind/bcp_sendrow etc).|||Check out the SqlBulkCopy class in System.Data.SqlClient in .NET Framework 2
.0
Linchi
"don larry" wrote:

> Greetings,
> In SQL Server (7, 2000), can we bulk insert data from a data structure
> (any possible kind) from the memory without using physical file as
> source.
> Thanks in advance,
> Don
> *** Sent via Developersdex http://www.examnotes.net ***
>|||Thank you Linchi (and unknown user), i appreaciate the feedback.
Alex
*** Sent via Developersdex http://www.examnotes.net ***