Viewing 15 posts - 496 through 510 (of 551 total)
Thank you Ravi-ji, Interesting one. π
(Though I selected the wrong answer, assuming that bulk import is on huge data and dropping indexes will improve the import process... and was considering...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 11, 2012 at 12:51 am
Lynn Pettis (9/10/2012)
Just a note, I try to write all my code as if the database was case sensitive. If a table is named ZipCode, then that is how...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 11, 2012 at 12:17 am
Hugo Kornelis (9/10/2012)
Raghavendra Mudugal (9/10/2012)
Hugo Kornelis (9/10/2012)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 10, 2012 at 5:34 am
Hugo Kornelis (9/10/2012)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 10, 2012 at 5:03 am
Simply Nice. π
(as the either way the implicit conversion is allowed, it will work if the data in the col is numbers, but one of the row contains the chars...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 9, 2012 at 11:35 pm
Michael Lysons (9/7/2012)
DugyC (9/7/2012)
What a fun question, thanks.Actually, yeah it was - well said π
+1
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 7, 2012 at 3:32 am
Awesome. π thank you Kenneth.
1. it will insert 1 record - FROM INSERT INTO
2. it will insert 1 record - But the count in table is 2 - from INSERT..SELECT
3....
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 6, 2012 at 11:14 pm
Thank you, Bitbucket. This question is very nice.
Initially I picked 6 and then changed to 5, thinking of the S in A has 6 unique value and then R in...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 6, 2012 at 12:47 am
Hugo Kornelis (9/5/2012)
This question (the second, chronologically) basically asked which of the insert formats used would fail and which would work.
Yes, from the previous post it has been proved that...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 5, 2012 at 3:56 am
L' Eomot InversΓ© (9/5/2012)
Raghavendra Mudugal (9/5/2012)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 5, 2012 at 2:20 am
Thank you. Nice.
(same as this http://qa.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 5, 2012 at 12:41 am
Awesome, good question, thank you. π
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 4, 2012 at 3:17 am
Good question. Thank you.
I has selected "simple talk..." before but I had a doubt and made a quick search in my email for the words and selected the 3 opt...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 3, 2012 at 1:50 am
Thank you Lokesh-ji, Nice question.
(So simple and yet it keeps us thinking..., to be honest I selected E,E and then seeing 2nd one's datatype as varchar, but the ISDATE...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 27, 2012 at 10:59 pm
Good question, thank you Lokesh-ji.
Initially I checked the cb-3 box where it stores the poor query details - considering the trace tables from the server-wide catalog tables, but later I...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 24, 2012 at 1:06 am
Viewing 15 posts - 496 through 510 (of 551 total)