Viewing 15 posts - 286 through 300 (of 455 total)
If you can't explain the criteria for inclusion in the result table, I don't think we can help you. For example, why is 'R' not included anywhere in the result...
March 20, 2012 at 11:48 am
Koen Verbeeck (3/20/2012)
When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.
Information that is stored in...
March 20, 2012 at 8:18 am
Raghavendra Mudugal (3/1/2012)
sknox (3/1/2012)
hamid_exe2007 (3/1/2012)
Because the ANSI_NULLS is on, if you set it off , it will show and work
If you set ANSI_NULLS off, your code will be incompatible with...
March 1, 2012 at 7:10 am
omyrox (3/1/2012)
Agreed on #1On #2: In the explanation they say that the problem is basically that NULL is not the same datatype as 'Idle',
The explanation is wrong. NULL is...
March 1, 2012 at 7:05 am
hamid_exe2007 (3/1/2012)
Because the ANSI_NULLS is on, if you set it off , it will show and work
If you set ANSI_NULLS off, your code will be incompatible with current standards and...
March 1, 2012 at 6:13 am
Hugo Kornelis (2/14/2012)
Koen Verbeeck (2/14/2012)
kll 51891 (2/14/2012)
But it were not so
Anywhere I can find specific rules about...
February 14, 2012 at 11:05 am
Good question! I was slowed by my brain's continued refusal to accept SQL's ability to accept statements delimited by nothing but a space, but I did manage to figure it...
February 14, 2012 at 10:45 am
sjimmo (2/10/2012)
Hugo
And I have never seen a real-world case where there was more than a single index on a view
Does that mean that there couldn't be more than one? Does...
February 10, 2012 at 10:08 am
Hugo Kornelis (2/10/2012)
February 10, 2012 at 5:46 am
L' Eomot Inversé (1/27/2012)
sknox (1/27/2012)
January 27, 2012 at 12:44 pm
Am I the only person that is frustrated when questions are posted as a picture, instead of text that can be copied and pasted for further experimentation?
Nope you're definitely not...
January 27, 2012 at 12:31 pm
SQL Kiwi (1/26/2012)
For anyone that wants to play with the XML, I think this is about right:
DECLARE @x xml =
N'<toys>
<myToy>
...
January 27, 2012 at 8:44 am
I got it right for the "wrong" reason: I reasoned that 2 had to be false, because nothing is stored in a view. A view is by definition a mechanism...
January 18, 2012 at 8:13 am
Thomas Abraham (1/5/2012)
arun1_m1 (1/5/2012)
Thomas Abraham (1/5/2012)
And then I started thinking ......
January 5, 2012 at 9:08 am
I've seen this crop up enough time on the forums to see why it rates 2 points.
While the answer is super-easy if you know DATETIME, this question highlights one of...
November 17, 2011 at 6:31 am
Viewing 15 posts - 286 through 300 (of 455 total)