User Profile

Collapse

Profile Sidebar

Collapse
ericdugas
ericdugas
Last Activity: Mar 26 '07, 12:19 AM
Joined: Mar 24 '07
Location: Louisiana, USA
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ericdugas
    replied to Concurrency Issue
    in SQL Server
    That is not acceptable in this case. The reason being it is a legacy app that generates autonumbers for different ranges for many different entities. Basically, if I were to use an identity column, I would have to have a different table for each entitiy, which would mean about 500 different tables.
    See more | Go to post

      Leave a comment:

    • ericdugas
      started a topic Concurrency Issue
      in SQL Server

      Concurrency Issue

      Hello All,
      Basically I am trying to implement assigning of unique consecutive integers from a particular row in a table in MSSQL 2000.

      Example pseudocode:

      <code>
      SET ISOLATION LEVEL REPEATABLE READ

      SELECT @VAR1 = NextAvailableNu mberColumn FROM TheTable WHERE pk=@pk

      UPDATE TheTable SET NextAvailableNu mberColumn = @VAR1 + 1 WHERE pk=@pk

      RETURN @VAR1
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...