Viewing 15 posts - 16 through 30 (of 31 total)
Got this one right after a lot of reading.. Thanks for a good qotd..
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 18, 2013 at 11:37 am
an easy one to start my day...and its a friday!!!!!!!!!! 😀
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 15, 2013 at 6:36 am
Hugo Kornelis (2/13/2013)[/b]
I do not agree with some of the comments here that time zone of the computer was required to answer this. Once I saw that the time portion...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 13, 2013 at 12:56 pm
archie flockhart (2/12/2013)
I selected "none of these are correct".
The third is wrong because the requirements are that the three rows for each person are produced with a 1 on the...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 12, 2013 at 8:29 am
Thanks for the reply. I did find the soultion. The allow_inprocess option in the properties dialogue box for the OLEDB provider should be checked. I didn't completely understand for what...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 11, 2013 at 9:00 am
I really wasn't sure if I have to 'GO' or not to 'GO' for my answer...I GOed and got it right..So what I learned from this Qotd is whenever there...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 11, 2013 at 8:22 am
From what I read in BOL, the first time a full text query uses an updated thesaurus file, it automatically loads the thesaurus file.. I have to check if it...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 8, 2013 at 12:17 pm
Thanks for the reply..
Quoted identifier is already on. turning it off is throwing incorrect syntax error. I believe it has something to do with the Oledb provider seetings but what...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 7, 2013 at 10:26 am
All you need to know to answer this question is that parenthesis override any operator precedence. The answer is easily arrived at by finding the odd man out among the...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 6, 2013 at 12:59 pm
A great qotd and explanation. Had thunk it many times before getting it right... 🙂
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 5, 2013 at 9:21 am
Easy one in a superbowl hangover..Thanx 🙂
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
February 4, 2013 at 7:21 am
If a starter like me can realize the inherent drawback in this question (need dataset), I guess its not a good question for Qotd
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
January 28, 2013 at 10:08 am
Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.
I checked the messages tab and didnt get the 1 row affected message.
I am...
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
January 22, 2013 at 9:18 am
I am a starter in sql server..
Can some one let me know why i dont get the 1 row(s) affected message as stated but simply
Command(s) completed successfully message..
___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:
January 22, 2013 at 7:55 am
Viewing 15 posts - 16 through 30 (of 31 total)