it will bring all the values of a col in a variable comma seprated, this is what i want.

so there will be one row two cols with comma seprated values...

hi,

i am using sql trace but following link says

https://msdn.microsoft.com/en-IN/library/ms186265(v=sql.105).aspx

"Lock mode of the lock acquired. This column is not populated by the Lock:Released event"

and the col...

thank u, i am trying sqltrace, but my second question is unanswered.

yorus sinclery.

well i have made a stored procedure with a loop which calls the main stored procedure after 20 seconds.

I am planning to make one windows service which will call my...

ya, i have seen them before, but they all are talking about with in "a transaction".

somthing like this

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

BEGIN TRAN

select * from wt

SET TRANSACTION...

As far as figuring out answer is concern i will find other answer to solutions,

but i wanted to know is sqlserver can run in this case or not,

"changing isolation...

is there any place where i can search it.

please send me link.

yours sinclerey

two server can have same timezone and they can get updated from internet also, but will they keep same datetime uptothe second over time.

yours sincerely

Should i post it in any other category?

yours sincerley.

thank u,

I wanted to know , why msdn says to use it , though the excution plan shows some more task is done

when some .write...

In q1) I wanted to ask about...

1)

update t1

set a, b, c, d .f

from t1 a

join t2 b on a.poleid=b.poleid

join t3 c on b.t3id = c.t31d

where b.poleid =1

2)

update t1

set a, b, c, d .f

from t1...

ya bigger and smaller is number of rows.

yours sincerely

questions are inside Q1)Q2)Q3)

yours sincerley

Sir, I will do it)

my expectaion was, that i will get some thing written from microsoft.

so please send any...