Viewing 15 posts - 916 through 930 (of 1,048 total)
bcoz cursor works on row-by-row basis taht why it takes long time to execute if there are execess rows in your table...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 7:23 am
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?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 7:16 am
i forget to paste the last lines of close and deallocate cursor plzz make them include
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 7:06 am
EASY ONE FOR THE DAY 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 5:46 am
very easy question to get +1 point 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 5:17 am
bad day 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 5:14 am
what a question it is//:w00t::cool:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 5:08 am
truly saying am not clear with the wordings of the question and lose points due to that 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 5:01 am
i think Disabling the trigger is the suitable answer for this..
i got wrong for this queston...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 4:58 am
good intresting question......
its a weird thing that it works good for 10 9s and 8 9s but not for 9 9s....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 3:36 am
tricky question..
for this question you must have detailed knowledge
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 3:13 am
good question again....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 3:07 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 2:52 am
good Question....
great explanation from all you guys 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2012 at 12:09 am
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.......
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 15, 2012 at 11:53 pm
Viewing 15 posts - 916 through 930 (of 1,048 total)