Skip to Content
0
Former Member
Aug 05, 2005 at 08:43 AM

Transactionhandling / locks on table.

11 Views

Hi,

I've read some facts about transaction handling / Locking.

I have a table ZPRICECOND_TAB that needs to be updated every 4 h.

Table ZPRICECOND_TAB has:

Rows: 100.000

Fields: 15

Primary key: 3

Other: runnig sqlserver2000 on windows.

So now I think I need to make the following statement.

delete from ZPRICECOND_TAB. " empty this table

insert ZPRICECOND_TAB from table i_pricecond3100.

insert ZPRICECOND_TAB from table i_pricecond4100.

Q1: How do I do a proper transaction/locking on this table ?

Dirty reads are OK... but there must always be data in the table...locks/waiting are ok as well...

// Martin