Probably, SQL Server 7 - DTS first implementation, and SQL 2005 with SSIS as an upgrade of DTS.

Nice easy question, good practice - use parenthesis. Thanks.

I like this question. Thanks.

Great question. I didn't know that. Thanks Evgeny

Yesterday's Question (by Steve Jones):

Which of these features cannot be used in SQL Server 2016 SP1+ Standard Edition?

Answer: All can be used

Explanation:

With the changes in SQL Server 2016...

Interesting question. I learned something new. Thanks!

mtassin (1/15/2016)

---

Steve Hendricks (1/14/2016)

---

I cry foul!!! As James Lean has pointed out, the INFORMATION_SCHEMA.ROUTINES returns both stored procedures AND functions!!! Without the additional filtering, it would be analogous to saying...

Same. "information_schema" - too much typing 🙂

To my opinion, the correct answer is 1,2,3.

The questing was "should you avoid" and the answer is: "Yes, you should". For different reasons, but avoid.

Good question. Thanks!

Great and helpful question. I didn't know that. Thanks!

NBSteve (11/21/2014)

---

For those looking for more of an explanation:

While poorly framed, it appears the intent of the question is to determine which queries will perform a SEEK versus...

Interesting question and great helpful suggestions!

Good question. Never thought about using the second option. I learned something. Thanks!

RK Mandava (9/30/2014)

---

We will get up to 20 different values depends on the database and sql version. So the answer should be 20

However, the explanation as to why 2 is...