Viewing 15 posts - 1 through 15 (of 37 total)
My question is: just "may" [sometimes]? or "always [any data] do"?
January 28, 2013 at 11:44 am
Fine!
Are the folowing two SELECT statements equvalent (i.e. -- see my original question, -- "return exactly the same row set" no matter "what data is")?
[font="Courier New"]SELECT xx FROM yy WHERE...
January 28, 2013 at 10:54 am
I need to optimize some non-SQL code that composes SQL statements dynamically. Some pieces of code look very much alike, but put the a priori non-aggregate condition either in HAVING...
January 28, 2013 at 9:04 am
Consider the condition Count(something) > 2
Richard, please heed my note about syntactically correct and aggregate functions.
January 28, 2013 at 8:13 am
I wouldn't use "correct".
Me neither, but in the next sentence you are using exactly wording of mine.
And besides, could you please offer your Yes/No answer to my question I...
January 28, 2013 at 8:10 am
Thank you, Koen. I parenthesized the quoted phrase because I deem it's an implication of "both statements are syntactically correct". Isn't it?
January 28, 2013 at 6:50 am
In my understsnding of the quoted code it means (shortly) the following:
Pass initialized...
August 14, 2012 at 11:23 am
Fantastic! How could I not know I have been balancing so close to my maxim "Oh, this is for others, for me Unicode is about the same as ASCII; longer?...
March 27, 2012 at 9:24 am
I suppose that any application (Mgmnt Studio included) takes databases list from sys.databases, and it is this place where unaccessible databases are expected to be excluded from.
Well, db naming conflicts...
May 7, 2009 at 12:37 pm
Thanks, RBarryYoung.
This had been my conclusion, and having been discontented with it I initiated this thread. I thought I was missing something. The requirement looks so natural, and I --...
May 7, 2009 at 11:58 am
Let me rephrase my question.
I am a system administrator and my login is "sa".
sa login owns database [pacrat]
What TSQL command(s) should sa execute in order to make a given database,...
May 7, 2009 at 11:28 am
revoke view any database to public
create login te0507 with password='111111'
Now my login te0507 cannot see a single user database name (the two sytem databases apart).
[font="Courier New"]
select name from sys.databases
name
--------------------
master
tempdb
(2 row(s)...
May 7, 2009 at 10:22 am
>>By granting privileges the right way.
Now I know I was wrong when I thought "by granting pivileges the wrong way."
May 7, 2009 at 8:43 am
>>How are they seeing Databases that they do not have any access to?
Easy, please see the attached image.
My question is: "Is it possible and if yes, what needs to be...
May 7, 2009 at 7:54 am
Viewing 15 posts - 1 through 15 (of 37 total)