Viewing 15 posts - 8,371 through 8,385 (of 14,953 total)
"Between" doesn't do what you want it to do. I'm not sure what you want it to do, but it isn't used for assigning values. It's used to...
- 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
September 15, 2009 at 12:41 pm
Take a look in Books Online (or MSDN) for "Common Table Expression". Specifically, you want to look at Microsoft's examples for a hierarchy, using a recursive CTE. It's...
- 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
September 15, 2009 at 12:26 pm
Since childhood, I've always spent a huge percentage of my time educating myself. It's fun, effective, and I get to study what I consider interesting and at my own...
- 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
September 15, 2009 at 7:12 am
I worked out the ROI and cost-of-implementation for buying monitoring software vs building it ourselves. Buying would, long-term, cost less, and short-term, be in place immediately, while building would...
- 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
September 15, 2009 at 7:02 am
george sibbald (9/14/2009)
I presume there is a duplicate somewhere?...
- 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
September 15, 2009 at 6:58 am
The ::= means "replace this placeholder with one of these options", basically.
Here's the syntax you're looking for:
use master;
go
alter database proofofconcept set offline;
"proofofconcept" is the database name. You'll have to...
- 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
September 14, 2009 at 12:39 pm
Sound judgement, there.
As Dilbert's Pointy-Haired-Boss once said, "100% of employee sabotage is by employees".
- 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
September 14, 2009 at 12:30 pm
It depends on how you implement your calls to the server, and how you build your stored procedures.
For example, if you build an SQL string in ASP.NET, and then execute...
- 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
September 14, 2009 at 11:46 am
Suleman, what kind of objects are you trying to create in these databases? Are you trying to auto-create everything the devs create in the base database, or just some...
- 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
September 14, 2009 at 8:39 am
Dave Ballantyne (9/14/2009)
Matt Whitfield (9/14/2009)
Bob Hovious (9/14/2009)
It means Ni?Does it always?
No, not when the knights who say ni are no longer the knights who say ni, but the knights who...
- 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
September 14, 2009 at 8:35 am
You could use correlated inline queries.
select Col1,
(select ColA
from dbo.Table2
where ColB = Table1.Col2) as ColA
from dbo.Table1;
This is even worse...
- 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
September 11, 2009 at 1:26 pm
Restore the database, just like you would in any other case, so far as I know.
- 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
September 11, 2009 at 1:20 pm
You could insert the data from the first table into a temp table that has all the columns you want to end up with, then use update commands to pull...
- 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
September 11, 2009 at 12:38 pm
ta.bu.shi.da.yu (9/11/2009)
I nearly choked when I saw that 🙂
BTW, on a more serious note: I know there are a lot of Americans on this site. I'd just like...
- 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
September 11, 2009 at 7:30 am
ta.bu.shi.da.yu (9/11/2009)
Paul White (9/11/2009)
Gianluca Sartori (9/11/2009)
Paul White (9/11/2009)
Though I must say that I agree with Ian Scarlet, Silverfox, and teletubby.Who's Teletubby?????
Did I miss something?
Sorry - ta.bu.shi.da.yu 🙂
I don't mind people...
- 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
September 11, 2009 at 7:27 am
Viewing 15 posts - 8,371 through 8,385 (of 14,953 total)