July 9, 2012 at 9:43 pm
Good question
M&M
July 9, 2012 at 11:37 pm
I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
July 10, 2012 at 12:20 am
rhythmk (7/9/2012)
I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:
+1
July 10, 2012 at 12:50 am
Easy point, thx!
July 10, 2012 at 1:30 am
Easy one
July 10, 2012 at 1:43 am
Nice one,thank you for the point.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 10, 2012 at 1:59 am
Pretty confident the answer would be an error, but I had to go and test it because the question specified SQL 2012 and I thought they might have changed it!
July 10, 2012 at 2:17 am
kupy (7/10/2012)
rhythmk (7/9/2012)
I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:+1
+2 !
July 10, 2012 at 3:04 am
Toreador (7/10/2012)
kupy (7/10/2012)
rhythmk (7/9/2012)
I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:+1
+2 !
+3...
July 10, 2012 at 3:04 am
I thought this must be a trick question, but no...
July 10, 2012 at 3:11 am
Well this has been the definition from 6.5. Actually I was confused by the fact of SQL 2012.
But eventually the definition does not change at all.
+1.
July 10, 2012 at 3:12 am
paul.knibbs (7/10/2012)
Pretty confident the answer would be an error, but I had to go and test it because the question specified SQL 2012 and I thought they might have changed it!
+1
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
July 10, 2012 at 4:35 am
Thanks for the question.
KR,
Iulian
July 10, 2012 at 4:44 am
rhythmk (7/9/2012)
I got the answer in first click but then I thought what if SQL 2012 get WHERE clause in TRUNCATE command :hehe:
I pondered that, and tried to think of a way it could be written to only deallocate* selected pages, and couldn't figure out a quick way it could have been implemented.
Then I wondered if it could have been changed to ignore the erroneous clause... but decided that would create an even larger hue and of course cry. "No No..." I told myself, "the current behaviour is perfect. They couldn't possibly have changed it."
---====####====----
* "Deallocate"... or is there a more proper term for what TRUNCATE does?
Viewing 15 posts - 1 through 15 (of 39 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy