Viewing 15 posts - 1,576 through 1,590 (of 3,347 total)
marcia.j.wilson (10/16/2013)
What would be some real-life situations in which you would use nested transactions?
I have not seen any practical use cases for direct nesting of transactions in a single code...
October 16, 2013 at 4:25 pm
L' Eomot Inversé (10/16/2013)
October 16, 2013 at 4:12 pm
ronmoses (10/15/2013)
Hugo Kornelis (10/15/2013)
ISNUMERIC returns 1 if the input can be converted to a numeric data type. It doesn't bother to tell you which data type.
I've yet to discover what...
October 15, 2013 at 2:54 pm
Dhruvesh Shah (10/14/2013)
Good question. Any one know why it returns 1 for some/most of special characters?
ISNUMERIC returns 1 if the input can be converted to a numeric data type. It...
October 15, 2013 at 2:28 pm
marlon.seton (10/15/2013)
David Burrows (10/15/2013)
Hugo Kornelis (10/14/2013)
October 15, 2013 at 1:22 pm
Good question, and a good additional link posted by raulggonzalez - I was already getting ready to jump in with additional explanation, but I don't see the need after reading...
October 14, 2013 at 11:23 am
I almost got it wrong because of miscounting the number of extra columns. Was looking for a "10" answer in the wrong position. The only reason I ended up getting...
October 11, 2013 at 3:40 pm
jfgoude (10/1/2013)
I wonder why Hugo did not answer L'Eomot, is he ill ?
If Tom asked me a question in this topic, I overlooked it. I still don't see it now....
October 9, 2013 at 2:25 pm
L' Eomot Inversé (10/9/2013)
October 9, 2013 at 2:20 pm
L' Eomot Inversé (9/27/2013)
BEGIN{ sql_statement | statement_block }
END
seems to make it quite clear that if you write...
September 27, 2013 at 11:25 am
SQLRNNR (9/26/2013)
Mr. Kapsicum (9/24/2013)
but what about ;(semi colon) of WITH ?i guess, it should generate an error? :discuss:
semi-colon ( ; ) is a statement terminator.
It is not required to begin...
September 27, 2013 at 12:19 am
L' Eomot Inversé (9/24/2013)
I knew the answer, but Jens-Peter's comment made me wonder: he's quite right, the behavious is not documented on the page referenced. Nor is it...
September 24, 2013 at 4:11 pm
So why does the question use dynamic SQL? If the focus is on how different kinds of comments relate, why not simply use:
-- /* select 'Samith' name
*/ select 'sas'
September 24, 2013 at 12:40 pm
I'm glad to see that a better reference has already been given. Saves me the trouble of looking for it.
An interesting thing (maybe already mentioned in the discussion - I'm...
September 19, 2013 at 12:45 pm
Steve Jones - SSC Editor (9/16/2013)
If someone has a good explanation that makes sense, I'm happy to change it.
The batch is processed in two phases.
Phase one is parsing. This works...
September 16, 2013 at 12:17 pm
Viewing 15 posts - 1,576 through 1,590 (of 3,347 total)