hi all,
  I uses delphi 2.0 & MSSQL 6.5 SP4, and test in  Single user.
 Now I have a Table SPRD with following structure:
  YY:             int
  MM:           int
  WH:           char
  PRD_NO:  char
 QTY:           float

data may be:
  1998,5, A0,0001,3.0
  1998,5, A0,0002,2.0
  1998,5, A0,0003,3.0
    ...... may records.

now I want append these records to this table(SPRD) ,just change MM from
5 to 6,
How can I do? why DeadLock occur? I try many methods, if records exceed
some
value, then blocked process occur. Does this MSSQL's bug? Why Oracle
doesn't
have these trouble!
  Thanks a lot!

How about posting some code..?

Rkr

--
                   \|||/
                   /'^'\
                  ( 0 0 )
--------------oOOO--(_)--OOOo--------------
. Reid Roman                              .
. Delphi Programmer / Analyst             .
. TVisualBasic:=class(None);              .
. May the Source be With You              .
-------------------------------------------
. Auto-By-Tel (http://www.autobytel.com)  .
. Irvine, CA U.S.A                        .
. E-Mail : rkroman (at) pacbell (dot) net .
. or reidr (at) autobytel (dot) com       .
-------------------------------------------