Using a stored proc to insert data...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi. I'm having a good deal of difficulty setting up what should be a simple
insert command to a SQL server table. I read in a set of records from a flat
file (which I've tested and this part works fine). I then need to simply
insert these records into a table. What are the basic steps I need to
complete to send this XML data to my stored proc so that it can update the
table? How/where do I reference the stored proc? Thanks for any help you can
give me.
.

Relevant Pages

  • Run a macro
    ... I'm working with a form in Outlook. ... In the form, i had a command ... button and i want to save some data in a sql server database. ... Prev by Date: ...
    (microsoft.public.outlook.program_vba)
  • DataTable empty when Stored Proc uses temp table
    ... I have a SQL Server 2000 Stored proc which creates a temp table and ... Prev by Date: ...
    (microsoft.public.dotnet.csharp.general)
  • Re: Parameters in .NET to OPENROWSET
    ... Given the stored proc: ... > @ID int OUTPUT ... why on earth are you connecting to one sql server just to have ... But the answer to your question is that in the command you've sent down @1 ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Replacement for VFP SEEK() Command
    ... You can always do a SELECT COUNTFROM MyTable instead of selecting some ... > to replace existing SEEKcommands with an SQL-equivelant command. ... > What is the best way to do this using SQL Server and stop using SEEK? ... Prev by Date: ...
    (microsoft.public.fox.helpwanted)
  • How to connect Database??
    ... Tables on SQL server, but I don't know how to connect to database and open ... it,what's tools or what's command can I use?anybody can help?Thanks a lot. ... Prev by Date: ...
    (microsoft.public.pocketpc.developer.networking)