I would like to thank you for your comment especially Cheryl Marsh .

I did not mean to show off myself,I just wanted to share my Idea with you.

If you...

Hi Digs

consider the following table:

create table #test(id char(1),value int)

insert #test

select 'A',  2000

union all

SELECT 'A',3000

union all

SELECT 'A',1000

union all

SELECT 'A',1500

union all

SELECT 'B',1000

union all

SELECT 'C',5000

union all

SELECT 'C',1000

I think this is what you...

thanks a lot.I got the idea!

I really enjoy All About Transactions - Part 3.I am interested in to hear about your new  article which covers Bound Connections, Distributed Transactions .

I ran dbcc showcontig('dbo.Tb_Amz_UnitChange81') with all_indexes  here

are the results:

DBCC SHOWCONTIG scanning 'Tb_Amz_UnitChange81' table...

Table: 'Tb_Amz_UnitChange81' (1280723615); index ID: 1, database ID: 7

TABLE level scan performed.

- Pages Scanned................................: 1427

- Extents Scanned..............................: 182

-...

Thank you so much.I am going to change all hold lock with UPDlock.

I have a table like the following:

CREATE TABLE test (Id int primary key,blah varchar(30))

and a stored proc like this:

create procedure usp_test @p varchar(30)

as

declare @nextid int

begin tran

select @nextid=count(*)+1

from test(holdlock)

insert test

values (@nextid,@p)

commit...

According BOL

quote:

---

Use update locks instead of shared locks while reading a table, and hold locks until the end of the statement...

Thanks Frank .I mean Enterprise Manager .

OR Try This:

SELECT *

FROM OPENXML (@idoc, '/criticalityquestion/optionvalue',2)

WITH (optionvalue varchar(20) 'text()')

if you take a look at design of syslogins you cannot see this column .is the isntname column hidden?

It will fire once.

I think i misunderstand the clustered index!

I have a table with the following structure

CREATE TABLE [Tb_Amz_UnitChange81] (

[Fd_Ucg_Term] [char] (8) ,

[Fd_Ucg_Regno] [int] NOT NULL ,

[Fd_Ucg_ClassId] [int] NOT NULL ,

[Fd_Ucg_CourseId] [int]...

Beer is not cold and it's not fizzy

hey phillcart

did you see my post?your reply is exacttly similar mine!!!