I wonder why there is no feedback from the Author of the Question.

I also wonder whether I should make a second post since I lost two points 😀

Hm, I guess there is something wrong with the question.

Since TEXT datatype is deprecated as well, it is perfectly valid to use UPDATETEXT.

And besides this, .WRITE doesnt work for TEXT...

Thanks Paul!

Friday 13 is actually a good day!

I just passed the last exam (70-442) of MCITP - Database Developer a few hours ago 🙂

And I even passed this question with a...

Thanks for this clarification, Tao!

Good Article and Good Topic.

I also stumbeled accross the oracle timestamp issue and used TO_CHAR as well to get around it.

Btw, here is some information regarding the deprecated timestamp datatype...

Since I have no ASP.NET experience, could someone please explain to me how this works?

I can imaginge that a textual result can be used for display in webpages, but what...

You should be able to read this from the registry. But why would you want to determine the network protocol settings via SQL?

Can you please specify what your expected result would be for the example given?

Hi Marcus,

your query looks a little messed up.

Try to rewrite it from scratch.

To replace singlequotes, use this format: REPLACE('stringxy' ,'''','')

Ok, back to work then 😀

ammon (6/2/2008)

---

Good point. Unfortunately, its hard to know the answer to that question now. I just wonder how hard it would be for me to determine what I thought...

ammon (6/2/2008)

---

Unfortunately that isn't possible in our system....

Btw, congrats, Matt to your 4444th point 🙂

Well, optional parameters are a good thing to have, but they should usually be applied next to mandatory parameters, unless you are working with a small data set.

Dynamic SQL doesnt...