1)"Under what circumstances will changes be made to the glues on the marbles and the sequencing?"

Glueid in marble table is only changed, When we want two marbles be connected to...

following is the step:

initially some sequence is given to marble table, at that time glueid in marble table are kept null.

then one by one glue is attached to marble to...

--All the marbles should be in order, Relating to the new attached glues.

1)ok, that means both queries are correct any one can be used?

2) i have chainged the join a.aid=i.aid

select a.aid, isnull(i.spoint ,j.spoint)

from #a a

left join #i i on a.Aid...

my question was some thing else , that is with out N it is working.

now u have written N which is also good , but i am trying to understand...

hi,

thank u,

i know about capital N , but i wanted to understand , if i have not used any char of Unicode in my xml, then why

capital...

yes i think this was the reason

well some body said DBCC UPDATEUSAGE (0); is also needed, is it correct?

i known begin tran and try cache , what i am asking is, which stmt might be the reason of generating this error.

your sincerley

thank u , but my query was , will try cache block any thing?

yours sincerley

i thought like transaction blocks , so it will also block

yours sincerely

no body is answering.

one more question

Q1 "set xact_abort no" should be the first stmt or set isolation level

that means

should i use like so.

set xact_abort no

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

or

SET...

yes , multiple user can have different col name.

q2) is not answered. will it do any good by removing or deleting.

pls answer

it is was not duplicate , i have overwritten the old one, becasue old one had got syntex error ( while typing)

so please consider the question. is the query ...