January 15, 2009 at 2:23 pm
How can select list of databases that starts after alphabet 'M".
January 15, 2009 at 2:27 pm
You mean sorta like this:
select
*
from
sys.databases
where
name > 'M';
January 15, 2009 at 2:27 pm
Not sure what you mean. Do you mean all databases on one server where the name starts with N or later in the alphabet?
It would be easy enough to either look at the list of databases in Management Studio, or to query the sys.databases table.
It seems, I must say, like an odd request. Any particular reason you need this data?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 2:28 pm
Lynn Pettis (1/15/2009)
You mean sorta like this:
select
*
from
sys.databases
where
name > 'M';
That would get databases that begin with M, I'm pretty sure. I think he wants ones that begin with N.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 2:33 pm
Depends on your interpretation of the requirements. MA is greater than M. :w00t:
January 15, 2009 at 2:37 pm
Lynn Pettis (1/15/2009)
Depends on your interpretation of the requirements. MA is greater than M. :w00t:
Yep. That's why I said, "I think".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 15, 2009 at 2:56 pm
Of course we won't know until the OP comes back. Looks like he isn't around SSC at the moment (14:56 MST).
January 15, 2009 at 3:03 pm
Lynn Pettis (1/15/2009)
Of course we won't know until the OP comes back. Looks like he isn't around SSC at the moment (14:56 MST).
For some reason I think this is another of those SET IT AND FORGET IT threads 😀
* Noel
January 15, 2009 at 3:05 pm
noeld (1/15/2009)
Lynn Pettis (1/15/2009)
Of course we won't know until the OP comes back. Looks like he isn't around SSC at the moment (14:56 MST).For some reason I think this is another of those SET IT AND FORGET IT threads 😀
Maybe, maybe not. He has been active on the site a while. Like I said, he could be off doing real work like we probably should be doing. :w00t::P
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply