Hi,

-- example table
CREATE TABLE dbo.test 
(
   id int IDENTITY (1, 1) NOT NULL 
  ,Tx char(10) NOT NULL
  ,Gruppo tinyint NOT NULL 
)

INSERT INTO dbo.test VALUES ('a',1)
INSERT INTO dbo.test VALUES ('B',1)
INSERT INTO dbo.test VALUES ('C',1)
INSERT INTO dbo.test VALUES ('az',2)
INSERT INTO dbo.test VALUES ('Bz',2)
INSERT INTO dbo.test VALUES ('Cz',2)

I need this:
- lock dbo.test for INSERT from other session
- allow SELECT from other session ( UNLOCK or READPAST )

I have resolve this.

I need this:
- lock dbo.test for INSERT from other session
only for INSERT with Gruppo=1
- allow SELECT from other session ( UNLOCK or READPAST )

Example:
if on another session is execute:
INSERT INTO dbo.test VALUES ('asdasd',2)
this command insert VALUES ('Cz',2) and can continue without problem;

if on another session is execute:
INSERT INTO dbo.test VALUES ('asdasd',1)
this command is locked and wait lock release.

I can do it on Microsoft SQL ?

On Oracle or DB2 a can do it ?

Fabio


I have resolve this.