Viewing 15 posts - 361 through 375 (of 552 total)
Thank you, Hugo. Glad I am on the same page. (but I still don't get the catch; possibly it may be what you have mentioned in the first line.)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
May 1, 2013 at 2:22 am
sorry; I have hard time in understanding/realizing the missing piece here.
- Replicate is replicating as needed (the expression is 5 chars and and @s-2 is also 5 so no...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
May 1, 2013 at 1:03 am
Awesome, thank you for posting.
(first thing I noticed this time was the missing of "EXISTS" in trigger and then "= 1" condition, that made it easy to mark the correct...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 25, 2013 at 12:21 am
Very interesting... thank you for the post. 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 24, 2013 at 3:10 am
Very very interesting one, thank you Tom for posting.(so simple and yet so complex)
I have one doubt - as the "nested" is out of the scope now it is just...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 23, 2013 at 6:41 am
Christian Buettner-167247 (4/22/2013)
For example, it is good practice to explicitly specify the nullability of your columns.
Had ANSI_NULL_DFLT_OFF for the session, the insert would...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 22, 2013 at 2:47 am
Nice one, thank you for posting.
(By seeing the output table.. it was sure that date is today's and from the options... I selected 4 quickly and then... realized the format...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 22, 2013 at 12:43 am
L' Eomot Inversé (4/19/2013)
Raghavendra Mudugal (4/19/2013)
(the word "attempt" confused me and I executed one after the other insert statement and as I imagined, it must...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 19, 2013 at 11:28 am
Good one; thank you for posting.
(the word "attempt" confused me and I executed one after the other insert statement and as I imagined, it must returned 3, and I was...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 19, 2013 at 10:06 am
Nice one, thank you for posting.
(I knew the row constructor can be used in inserting value with single insert and the separated by comma, but never made an attempt to...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 17, 2013 at 8:25 am
Awesome; thank you for posting.
I had same issue on the trigger with the same column where I was creating newly; when I literally tested the code even knowing...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 9, 2013 at 2:54 am
Hugo Kornelis (4/8/2013)
....I hope someone else can explain why a backslash at the start of the string is considered numeric, as I was surprised at that myself.
possibly can be this...
http://www.tru64unix.compaq.com/docs/base_doc/DOCUMENTATION/V40F_HTML/AQTLTBTE/DOCU_010.HTM
(scroll...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 8, 2013 at 3:38 am
mtassin (4/3/2013)
Koen Verbeeck (4/3/2013)
Explanation could have been a little bit better.And question a little bit shorter 🙂
/agree
Not even sure what purpose that function was supposed to solve.
If it was...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 3, 2013 at 8:02 am
(EZ PZ... steps-involved; copy; paste; ctrl+e; select-answer; submit; grin; tongue.)
Awesome; really nice question.
At first; i noticed was not - only one insert but the variable initialization is happening in the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 3, 2013 at 7:53 am
Awesome. Thank you for question and the points. 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
April 1, 2013 at 3:32 am
Viewing 15 posts - 361 through 375 (of 552 total)