August 25, 2009 at 3:08 pm
Hello,
I have a stored procedure which creates records in two tables when data is entered in one web form, there are around 15 parameters which send the data to the tables. What I been asked to create is to allow an XML file to be posted from the webform directly to the SQL Server then the stored procedure will read the XML and current functionality will populate the tables.
What I have found so far it seems the web service abilities in SQL only allow the getting of data not posting, is this correct or I am missing something?
The XML message has not be defined as of yet and there is no issue in using the HTTP EndPoints as the SQL Server 2008 will be deployed and operational for at least 10 years.
Many thanks in advanced for any pointers.
August 25, 2009 at 3:31 pm
I beleieve that you will need the WebForm to connect to you SQL Server and then call a stored procedure. You can write another stored procdure that can accept an XML document as a parameter, and then have it use the XML methods (.nodes(), .query(), etc.) to shred the XML into your parameters and then call you original, proc.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply