Viewing 15 posts - 376 through 390 (of 552 total)
L' Eomot Inversé (3/29/2013)
Thomas Abraham (3/29/2013)
Nice question, on a seemingly simple, but not so, issue. Thanks!... perhaps, but most of it must be people getting it wrong.
... and I am...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 29, 2013 at 7:37 am
Awesome, actually really nice one.
(I had developed imaginary theory on this long back- what if the table is self joined with the key and would truncate work? - and I...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 28, 2013 at 5:34 am
Good one, thank you for posting;
I actually selected 1 and 4 and really not sure what crossed my mind and I ended up selecting the other two... which lead to...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 26, 2013 at 3:08 am
Simply the best; thank you for posting.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 25, 2013 at 5:15 am
Thank you for posting, good one.
Never digged so deep on this area, was interesting to learn.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 22, 2013 at 4:53 am
Hugo Kornelis (3/21/2013)
...DML is language that inserted, updates, or deletes data. That (deleting data) is exactly what TRUNCATE TABLE does!
Thank you Hugo; but one doubt...
.... but still it is does...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 21, 2013 at 7:17 am
jpentz99 (3/21/2013)
MS docs sometimes refer to it as a DML operation as well:
"Some data manipulation language (DML) operations, such as table truncation, use Sch-M locks to prevent access to affected...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 21, 2013 at 3:44 am
good one. thank you for posting.
I guess it is a long fight because neither way it cannot be proved 100% that it is a DML or DDL depending on the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 21, 2013 at 3:43 am
peter.row (3/20/2013)
Basic question designed to seem like a trick?This applies equally to SQL Server 2005 and 2008 not just 2008R2 and 2012.
also... including our old friend SQL SERVER 2000
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 20, 2013 at 3:04 am
Simply Nice, thank you for posting.
(i knew this before, and just fews days ago i kind of helped a person online to fix this, so it was easy recall for...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 20, 2013 at 2:59 am
Simply the best, thank you for posting steve...
(i looked into the thesaurus file location on the hard drive and then noticed eng/enu two files but was not sure which one...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 19, 2013 at 3:30 am
Awesome Qtod,thank you for posting.
(I am bursting with my doubts... but no idea where to begin...)
so to say... there will be no row/s in the datetime column where it...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 18, 2013 at 3:07 am
ah ... this was soo easy, i just selected the answer in one click....:Whistling: but selected the wrong one. (interesting read, so far)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 15, 2013 at 3:31 am
Carlo Romagnano (3/13/2013)
okbangas (3/13/2013)
Learned something new here, and by the way, the reference should be:Good!
+1
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 13, 2013 at 2:59 am
Stewart "Arturius" Campbell (3/13/2013)
Interesting question, thanks DaveAnother way to check the detail of the temp table would be to execute
tempdb..sp_help #TempQoD
Now this is very very new thing to me......
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 13, 2013 at 2:25 am
Viewing 15 posts - 376 through 390 (of 552 total)