"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...

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...

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...

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...

george sibbald (9/14/2009)

---

Its not really the point of the editorial but I also was wondering what the DR strategy was for this data centre.

I presume there is a duplicate somewhere?...

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...

Sound judgement, there.

As Dilbert's Pointy-Haired-Boss once said, "100% of employee sabotage is by employees".

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...

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...

Dave Ballantyne (9/14/2009)

---

Matt Whitfield (9/14/2009)

---

No, not when the knights who say ni are no longer the knights who say ni, but the knights who...

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...

Restore the database, just like you would in any other case, so far as I know.

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...

ta.bu.shi.da.yu (9/11/2009)

---

The red one...

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...

ta.bu.shi.da.yu (9/11/2009)

---

Paul White (9/11/2009)

---

Sorry - ta.bu.shi.da.yu 🙂

I don't mind people...