Re: Saving a (whole) datatable in SQL Server 2000
- From: "William Vaughn" <billvaNoSPAM@xxxxxxxxx>
- Date: Mon, 12 Nov 2007 11:52:03 -0800
ADO.NET can do it using the SqlBulkCopy class.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"W.G. Ryan [eMVP]" <WGRyaneMVP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B8B13CFE-E03D-45F7-88F1-9807301FDF0A@xxxxxxxxxxxxxxxx
Pipo:
There are many ways to do this, do you want to use ADO.NET (which would be
quite slow and inefficient) or are you open to other technologies? You can
do a backup and restore for one thing, or you could write an SSIS package
(DTS if you only have 2000), or use BCP.
Can you tell me a little more about your goals and perhaps I can be of more
help?
Thanks,
Bill
"Pipo" wrote:
Hi,
I would like to save (and load) an entire datatable into SQL Server 2000.
Is this possible and has someone has some sample (code) for me?
tia,
Pipo
.
- References:
- Prev by Date: Re: Reading a SQLCLR Stored Proc. Result
- Next by Date: Re: Data reader / Serverside cursor
- Previous by thread: Saving a (whole) datatable in SQL Server 2000
- Next by thread: is it possible to mark my CLR function as UNSAFE in code or visual studio anywhere so that wehn vs deploys, it creates unsafe assembly? (instead of me having to manualy deploy in tsql!)
- Index(es):
Relevant Pages
|
