L' Eomot Inversé (3/1/2012)

---

I think there are actually three different things here, and I don't think there's two sides to...

Nadrek (3/1/2012)

---

GSquared (2/29/2012)

---

Woudn't bother using SSD for the O/S on a server, unless you haven't got any other...

To the question about the nested From statements:

Those are what are called "derived tables".

You can do those in the body of the "outer query":

select *

from

...

SQLKnowItAll (3/1/2012)

---

The semi-colon at the start of his query is actually bad when demonstrating the method used for creating a CTE. It's there to terminate the previous statement but is...

Cool biz.

Glad I could help.

I took a bit closer look at Explicit, and you can specify elementxsinil in the directive part of a column name.

Example at: http://msdn.microsoft.com/en-us/library/bb522622.aspx

Documentation at: http://msdn.microsoft.com/en-us/library/ms189068.aspx

I don't think Explicit mode supports XSINIL in the FOR clause, so what you probably have to do is wrap the appropriate column in IsNull/Coalesce.

Stefan Krzywicki (3/1/2012)

---

Revenant (2/29/2012)

---

L' Eomot Inversé (2/29/2012)

---

I know I say this every time... but...

The alleged shortage is of what it has always been - 21 year olds with 5 years...

Woudn't bother using SSD for the O/S on a server, unless you haven't got any other plan than...

If you're talking about Management Studio and Dev Studio (SSMS and BIDS), you shouldn't have any problem installing those on Win 7 64-bit. I've done that.

If you want to...

Brandie Tarvin (2/28/2012)

---

Gianluca Sartori (2/28/2012)

---

Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than...

satishm94 (2/28/2012)

---

Hi guys

can u guys tell me the answers to these question …PLZ

1)What is the purpose of Msdb database? If you delete msdb database insatance is running or not?

2)Login cannot...

Makes sense. You're welcome.

There are a couple of ways to do this.

Here are some samples. Try these, see if they get you started in the right direction.

DECLARE @XML XML = '<root><Books><Book><ID>2</ID><Name>Sql Server...

Explicit vs Implicit.

Same reason it has "top 100 percent" in the same query. No point to that, since Select without a Top clause automatically does that. It's just...