I use this command SELECT INTO to create a table in development environment, then

I use my personal EXEC sp_createtable 'TempTab' to generate the script for creating the table

and in the...

+1

😀

Good qotd, but too...

Danny Ocean (5/2/2013)

---

Most of people don't know about it because it's not in use in any real scenario. I never use this kind of table in production environment, But i...

Rune Bivrin (5/2/2013)

---

Hugo Kornelis (5/2/2013)

---

However, to do some nitpicking:

1. If I were to try this code on my system, I would get five errors. All system table (*) names are...

I like explanation!

😀

crussell-931424 (5/1/2013)

---

Hugo Kornelis (5/1/2013)

---

Raghavendra Mudugal (5/1/2013)

---

sorry; I have hard time in understanding/realizing the missing piece here.

- Replicate is replicating as needed (the expression is 5 chars and and @s-2...

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