Viewing 15 posts - 436 through 450 (of 552 total)
Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us....
I guess.. this; if the aliases are been removed in SELECT block, it gives below error on ambiguity for...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
January 9, 2013 at 7:16 am
Interesting question, thank you Tom.
(even kind of knowing the output for each select statement, it tempted me to challenge self and to prove it)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
January 9, 2013 at 7:03 am
asifkareem (1/1/2013)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/95322/">Round And Numaric</A>
it is something like this, the 123 and 100 are integers, but it is converted in to...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
January 2, 2013 at 3:37 am
andy.brown (12/31/2012)
... What is the connection between the acronym RAID and Microsoft here?
"RAID (redundant array of independent disks) levels 0, 1, and 5 are typically implemented with SQL Server."
Just...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 31, 2012 at 3:35 am
Phew! Toughest question of the year.
And a Happy New Year to you all. In the New Year, wish you the best year you've ever had.May you realize your fondest dreams...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 31, 2012 at 3:03 am
Jeff Moden (7/26/2012)
If you want an expert in SSAS,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 30, 2012 at 7:24 am
Fine learning... thank you for the question. (this is completely new for me) 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 29, 2012 at 12:05 am
Awesome. (this is really very interesting thing) thanks for the question.:-)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 28, 2012 at 11:51 pm
Very Nice QtoD. (the joins are finally getting stronger... 🙂 )
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 28, 2012 at 11:18 pm
Actually the "default value" in the link mainly tells on the default value of the DATETIME datatype and the date value is not beyond that.
The usage of the GetDate()...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
November 26, 2012 at 11:43 pm
nice 🙂 thank you for the question
(though it was simple and straight question, not sure why i kept occupied myself thinking as it was a trick question... :crazy:)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
November 22, 2012 at 10:29 pm
nice 🙂
(..actually came to know these levels 6 years ago, I used (NOLOCK) in the select statements on DWH queries and was wondering rather than typing nolock for each table...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
November 21, 2012 at 1:57 am
Nice, back to basics.
I don't use this in real-time scenario at all, but few weeks ago I was just looking at them just to refresh my memory. Infact I used...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
November 14, 2012 at 3:24 am
Nils Gustav Stråbø (11/13/2012)
Raghavendra, exactly. Keep it simple. That way you'llbe able to test the reader's knowledge about transactions. No need to add a lot of extra noise.
I agree...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
November 13, 2012 at 4:11 am
Nils Gustav Stråbø (11/13/2012)
Got it wrong because I missed the last INSERT statement after the WHILE LOOP.
If the intention was to test the knowledge of nested transactions...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
November 13, 2012 at 3:10 am
Viewing 15 posts - 436 through 450 (of 552 total)