Subscribe To

Subscribe to SQL Server and XML by Email

Sunday, December 09, 2007

Passing a Data Table to a SQL Server 2005 Stored Procedure

Moved to


  1. Anonymous8:32 AM

    Hello, I am trying your code and I get the following error message. Can you help?
    Msg 170, Level 15, State 1 Incorrect syntax near '.'.
    When I double click on the error is highlights FROM @data.nodes('/NewDataSet/Table') as x(d)

  2. Anonymous7:58 PM

    I am also getting the same error..

    How do we solve this?

    I know this is an old post.. But since I am getting the error I figured I would ask.


  3. This is nice sample code. I've used it and it works without any error.

    Indra Bisen

  4. I see two comments that mention an error. I could not figure out what is the problem. The script runs correctly on a few computers I tested.

    If you have any issues with this code, contact me at jacob[dot]reliancesp[at]gmail[dot]com and I will help you to fix it.


About Me
Jacob Sebastian
* XQuery Tutorials
My Links
SQL Server White Papers
SQL Server 2008
My Articles
XML Workshop RSS Feed
Contact me
Free Hit Counter
Web Site Hit Counters
SQL Server Bloggers
Blog Directories
blogarama - the blog directory Programming Blogs - BlogCatalog Blog Directory
Copyright Jacob Sebastian