What is the difference between the answer 3 and 6?

5, 3, 1

Bad question! Too much stuff, no value!

It's take too long to check all the script!

Knut Boehnert (4/18/2013)

---

Sorry, all you are saying is that a red sky is always better than a green sky. But not why.

Everyone knows...

Old stuff!

Dynamic sql will run better.

A simple CROSS JOIN!

🙂

Very easy!

sfayer (4/12/2013)

---

kapil_kk (4/12/2013)

---

AS per the explanation:

"You can create three payload types in SQL Server 2012: TCP, Service Broker, and Database Mirroring endpoints. SOAP endpoints were removed in SQL Server 2012."

When...

I suggest for next authors to keep in mind few rules:

1 Be simple

2 Be clear

3 Be synthetic

baabhu (4/3/2013)

---

For me at least option b and option d looks pretty much similar.

option B.

Query 1 will return all rows of table 1 and Query 2 will return...

These conversions are non deterministic, but from string to date:

from BOL:

Certain datetime Conversions Are Nondeterministic in SQL Server 2005 and Later Versions

In SQL Server 2000, string to date and time...

L' Eomot Inversé (3/20/2013)

---

demonfox (3/20/2013)

---

I prefer not to have delete cascade on design .. to let...

I do not like "[OrderID] [int] NULL," in the [OrderDetail],

so you can insert orphan records despite the constraint.

CREATE TABLE [dbo].[OrderDetail]

(

[OrderDetailID] [int] NOT NULL,

[OrderID] [int] NULL,

CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED...

Good qotd!

🙂

+1

Good!