Viewing 15 posts - 121 through 135 (of 220 total)
Parsers are allowed to cover other characters, that's case of IE and allows this result to be displayed.
I knew about illegal XML characters, but I felt there was a trick...
May 20, 2010 at 2:13 am
Kari Suresh (5/19/2010)
where and how we can use this? Anybody can explain with an example?
For example, it may be very useful when a big transaction rolls back and you want...
May 19, 2010 at 1:48 am
Nice question.
I answered wrong even after reading BOL. I definitely need to learn more about that dynamic views because they contain a lot of useful stuff.
Maybe the word "job" is...
May 18, 2010 at 2:31 am
tlewis-993411 (5/13/2010)
I'm not sure why the following code worksINSERT TestTable (string)
OUTPUT inserted.*
Doesn't the select return more columns (ID and String) than the insert list?
When a row is inserted into a...
May 13, 2010 at 7:15 am
WayneS (5/13/2010)
in the explanation, it should be the string 'AnotherString' to be replaced with 'Stub', not 'TestString'
You are right, thanks for the correction!
May 13, 2010 at 5:03 am
Toreador (5/13/2010)
So how would you get the identity values of the rows you'd...
May 13, 2010 at 4:51 am
Hugo Kornelis (4/22/2010)
Do you think you can post a repro script that actually uses this operator? Have you ever seen it used in your code?
Yes, sometimes I see this operator...
April 27, 2010 at 1:47 am
Lynn Pettis (4/26/2010)
What is interesting is that approximately a third of the respondents have gotten the question wrong.
I'm amongst that respondents because I haven't used @@error since 2006, and I've...
April 27, 2010 at 1:03 am
Hugo Kornelis (4/20/2010)
April 22, 2010 at 1:59 am
RBarryYoung (4/7/2010)
the error message 'a domain error has occurred'AFAIK SQRT, LOG and maybe POWER are the only things that return this error.
I vote for this list: SQRT, LOG, LOG10, POWER,...
April 8, 2010 at 12:54 am
Peter Trast (4/7/2010)
vk-kirov (4/7/2010)
Maybe because TRUNCATE manipulates metadata, not data? (It's my suggestion only)DOES truncate delete metadata??? (I am thinking no).
You are right. TRUNCATE does not delete metadata, it manipulates...
April 7, 2010 at 1:40 pm
Nice question.
Maybe I read it too fast: "Select all...", I selected "ABCD", then pressed the "Submit" button. Oops, there was "...that apply" part 🙂
It's interesting to explore the execution plans.
The...
April 7, 2010 at 2:05 am
Paul White NZ (4/6/2010)
You posted that link and statement before!
Oops... did I?.. :blush:
I just want to say that your conclusion "if a command deletes rows, it's a DML" may be...
April 7, 2010 at 1:21 am
Viewing 15 posts - 121 through 135 (of 220 total)