bcoz cursor works on row-by-row basis taht why it takes long time to execute if there are execess rows in your table...

Hi,

as in to fetch every row value we use statement-

fetch next from db_cursor into @fcity,@fstate

How using while loop I fetch every row value?

i forget to paste the last lines of close and deallocate cursor plzz make them include

EASY ONE FOR THE DAY 🙂

very easy question to get +1 point 🙂

bad day 🙁

what a question it is//:w00t::cool:

truly saying am not clear with the wordings of the question and lose points due to that 🙁

i think Disabling the trigger is the suitable answer for this..

i got wrong for this queston...

good intresting question......

its a weird thing that it works good for 10 9s and 8 9s but not for 9 9s....

tricky question..

for this question you must have detailed knowledge

good question again....

thanks Hugo for the explanation....

I am not much aware about this and only thing I knew that somewhat there is word like noise list in sql server 2005 that's why...

good Question....

great explanation from all you guys 🙂

As sql server version was not specified so I selected NoiseList but got wrong...

I think version should be mentioned in question..

learn new thing today.......