Loading user information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading user information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Using XQuery to Process a Stored Procedure

6 minutes, 39 seconds


Right click “Save as…”

Rob Daigneau takes a look at how you can process a stored procedure using XQuery, one of the new features available within SQL Server 2005.


Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation
  • i don't think using a date field to determine concurrency issues is a good practice.
  • Hello,
    Thanks for your comments.Smiley

    Yes, some people don't like using DateTimes to identify the "Lost Update" problem. This is a concern when a higher level of precision is required than what is offered by the DateTime (i.e. you have very high concurrency with lots of updates within milliseconds of each other). An alternative that many find acceptable is to use the TimeStamp data type.

    In any event, the primary concept here was really meant to be more about the neat things we can do with XQuery, and I do hope you found something useful there.

    Concerning XQuery, a member of the SQL Server Engine team recently contacted me about a few issues which I either did not address (e.g. performance of Value() vs. Exist(), using XML or VarBinary data types for input parameters rather than TEXT, code page and encoding issues ), or was unaware of (e.g. potential data corruption attributable to code page and XML encoding). He graciously offered to write a post on these subjects for www.DesignPatternsFor.Net in the next month or two.


    Rob Daigneau

Remove this comment

Remove this thread


Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.