Deadlock with read and update a simple table

• Miguel Ochoa

  SSC Rookie

  Points: 36

  More actions

  May 3, 2006 at 4:24 pm

  #90046

  I try to store a last document number for each deparment in a table

   

  CREATE TABLE [LastDoc] (

   [Department] [int] NOT NULL ,

   [LastNum] [int] NULL CONSTRAINT [DF_LastDoc_LastNum] DEFAULT (0),

   CONSTRAINT [PK_LastDoc] PRIMARY KEY  CLUSTERED

   (

    [Deparment]

  &nbsp  ON [PRIMARY]

  ) ON [PRIMARY]

  GO

  I create a store procedure to update the last number, This is a simplex example of my procedure

   

   

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  May 8, 2006 at 12:31 pm

  #636589

  First, please pay attention to where you are posting. This forum title is 'Anything That Is Not About SQL Server'. Notice the NOT........

  Second, you don't post a problem/question. What do you want to know?

  I suggest posting your question in an appropriate forum.

  -SQLBill