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.)
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...
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...
April 25, 2013 at 12:21 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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
April 3, 2013 at 7:53 am
Awesome. Thank you for question and the points. 🙂
April 1, 2013 at 3:32 am
Viewing 15 posts - 361 through 375 (of 552 total)