I'm not sure which build of 2005 are you using, but I've...

Richard Warr (3/14/2013)

---

Interestingly, if I run the code, I get:

Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to a datetime data type resulted in...

Very good script, although it produces a huge amount of...

I agree with you. The wording of the question is totally misleading.

demonfox (2/10/2013)

---

All the following statements,...

Dineshbabu (1/18/2013)

---

If we run the profiler before clicking Display Estimated Execution Plan, we can see SHOWPLAN_XML option is set to ON.

I think due to enabling this set option we...

The first two answers (100, 105, 105 and 105, 105, 105) cannot be considered as random guesses. So the further...

Another question about different stuff 🙂

An interesting example of inserting one string into another. Never thought it could be done that way. I always did it using something like

SELECT LEFT(@string1,...

seankyleprice (11/16/2012)

---

Best Practice for 2008 onwards is surely to use TRY CATCH as suggested by Stewart. For 2005 and prior I agree that the method suggested by Carlos would be...

Lon-860191 (11/8/2012)

---

Good question, but I would question if a method is reliable if it does not work less than 1/3 of the time daily, method 2 overloaded at 8 am...

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

---

Actually, I suspect that the correct way to write the condition, because a collate clause applies only to a single column or constant or variable, is

...

Nils Gustav Stråbø (11/1/2012)

---

vk-kirov (11/1/2012)

---

Note that the QOD query will return 139 characters if it runs on a database with the Latin1_General_CI_AS (or similar) collation. When running on a database...

Note that the QOD query will return 139 characters if it runs on a database with the Latin1_General_CI_AS (or similar) collation. When running on a database with another collation, the...

"Delete a row multiple times"...

Thanks for question about the new feature of MSSQL 2012!

Lokesh Vij (10/29/2012)

---

Hey Ron, There seems to be some confustion with answer choices here. When we have ORDER BY caluse on...

I think there's no practical purpose in such duplicate foreign keys. Some RDBMSs even do not allow these FKs. For example, you'll...