Thank u,

in 99 percent cases, i use set based approach , this was quite old situation , so i was forced to use loop.

but my question was to have that...

I got the point,

q1) that means if population is going to be whole number with out fraction.

that is converting using cast( '323' as decimal ) is write, because it has...

Basically example is dummy, i just wanted to undersand conversion to decimal so that i can get results in decimal.

why i have not taken any precision because , it will...

thank u,

in question no 4)

i wanted to know, type of files like, can i import xls ,.xlsx ,.doc using bcp or bulk import command.

yours sinclerye.

can i get any example or link

yours sincelrey

Basically i want to run a transaction between two different instance of server,

so that i can rollback task done at both the instances when ever i want.

so please tel me...

Quick questions:

1. Are all the columns used all the time ( no, few are not used at all and they are datetime, varchar,int)

2. Are the columns NULL-able? ( yes)

3....

each one is accessing different tables in different orders.

that means in my situation it can come, becasue the read comiited tran is only seclting.

and snapshot is only inserting update .

yours...

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...

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